I think it is just an excel quirk...

if you click away from the filtered worksheet it changes from the result to filter mode...but if you refresh the filter it comes back

Thus I don't think you can change it other than refreshing the filter

Posted By: Maillot Jaune on October 26th 2009 at 10:53:30

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.