LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hari
 
Posts: n/a
Default Applying auto-filter with large number of rows

Hi,

If I have lets say 3000 rows and 4 columns and If I want to use
Auto-filter on one column then the list of unique entries which
Auto-filter window offers is not complete. I see that this behaviour
happens when number of rows is "large".

Has anybody else experienced this problem?

(I know that one can use advanced filter by using criteria list, but
sometimes auto-fiter is "quicker" for some mundane tasks. Also, I
understand that in excel keeping so many rows is not good,but would
like to ignore it for the moment.)

Regards,
Hari
India

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
auto expand rows [email protected] Excel Worksheet Functions 3 December 14th 05 07:45 AM
Delete rows based on multiple criterias Benson Excel Discussion (Misc queries) 8 November 2nd 05 03:11 PM
How do I show number of records that meet criteria filter CliffD Excel Discussion (Misc queries) 3 August 22nd 05 01:10 PM
formula to use when number of rows changes dynamically confused Excel Worksheet Functions 3 August 17th 05 03:55 PM
Find the number of rows returned in a filter Tony W Excel Discussion (Misc queries) 5 May 30th 05 10:36 PM


All times are GMT +1. The time now is 04:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"