Non footy i'm afraid - Excel help required...

I'm trying to write a formula do a tally count of occurrences in a list where there are two conditions present.

i.e. only count occurences if condition A = "[text1]" and condition B = "[text2]"

Also,

I would like Excel to highlight the three highest values in a list, by colouring in the cell.

Can anyone help? As ever, quite difficult to find an answer by Googling...

Posted By: Yellalee on February 22nd 2006 at 14:06:45

Message Thread

Non footy i'm afraid - Excel help required... (General Chat) - Yellalee, Feb 22, 14:06:45
- Tuck your 'ifs' in after you've taken them up the wooden hill to Bedfordshire (n/m) (General Chat) - malkybarkid, Feb 22, 14:44:51
- Embed your Ifs innit (n/m) (General Chat) - Steve in Holland, Feb 22, 14:18:42
- Yep, Embed your Ifs. And then use conditional formatting. (n/m) (General Chat) - Arganth, Feb 22, 14:14:44
- Sounds like you need to embed if statements. (n/m) (General Chat) - BeverlyHills0201, Feb 22, 14:11:13
  - What does that mean? Never had to bed and 'if' before... (General Chat) - Yellalee, Feb 22, 14:26:50
    - Put an if statement inside an if statement (General Chat) - BeverlyHills0201, Feb 22, 14:31:24
      - cheers... i think ive got that... (n/m) (General Chat) - Yellalee, Feb 22, 14:33:43
    - *an* (n/m) (General Chat) - Yellalee, Feb 22, 14:27:14
  - Or even a pivot table. (n/m) (General Chat) - BeverlyHills0201, Feb 22, 14:13:58

Reply to Message

In order to add a post to the WotB Message Board you must be a registered WotB user.

If you are not yet registered then please visit the registration page. You should ensure that their browser is setup to accept cookies.