Excel question...

How to I get to see the results of an autofilter at the bottom of the screen?

Some worksheets, when I filter data, give a count result, e.g. 12 of 50

Some just say 'filter mode'.

I suspect I am being really rather dumb...

Posted By: Yellalee on October 26th 2009 at 10:25:20

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.