there is another quick way too

if you right-click in the bottom your excel window (the status bar i think it's called - where it says 'Ready' in the bottom-left corner) you can change what Excel does with selected cells - the default is Sum, but if you change it to Count and then do your filter highlight the whole of one of the columns filled with data and it should give you a count of the rows returned

Posted By: Ralf Scrampton on October 26th 2009 at 10:55:45

Message Thread

Excel question... (General Chat) - Yellalee, Oct 26, 10:25:20
- I think it is just an excel quirk... (General Chat) - Maillot Jaune, Oct 26, 10:53:30
- What version are you on? (General Chat) - lurd, Oct 26, 10:47:57
  - you could definitely do it with 2002, but again i don't think the row count was always giv (General Chat) - Ralf Scrampton, Oct 26, 10:50:40
  - no probs. I'm on 2003 as well. (n/m) (General Chat) - Yellalee, Oct 26, 10:48:46
- that's a good question that is, sadly one i don't know the answer to (General Chat) - Ralf Scrampton, Oct 26, 10:39:42
  - Yep, cheers. I did a Pivot Table in the end. A happy (alternative) ending (n/m) (General Chat) - Yellalee, Oct 26, 10:49:32
    - there is another quick way too (General Chat) - Ralf Scrampton, Oct 26, 10:55:45
      - Was gonna suggest that but thought it was too obvious.. (n/m) (General Chat) - lurd, Oct 26, 11:00:00
      - nice one, ta (n/m) (General Chat) - Yellalee, Oct 26, 10:56:31
        
        you could also GIYLF :-) (General Chat) - Ralf Scrampton, Oct 26, 11:00:28
        
        aha! That's it - I am using a lookup table formula on 15000 rows... (n/m) (General Chat) - Yellalee, Oct 26, 11:15:49

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.