Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
auto expand rows | Excel Worksheet Functions | |||
Delete rows based on multiple criterias | Excel Discussion (Misc queries) | |||
How do I show number of records that meet criteria filter | Excel Discussion (Misc queries) | |||
formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
Find the number of rows returned in a filter | Excel Discussion (Misc queries) |