Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to use the auto filter function on a sheet that has about 47000
rows in it. The column I want to auto filter has about 14900 different values in it. So many of the values are repeated. The problem is that when I open the auto filter, all of the different values are not available. Only the first 1000 of them. Is this normal? Is it a limitation of the auto filter function? I can use custom and pull the info that I need, so that is working. Just curious... Steven K. -- Steven Keeling Pal Services DSCR Richmond VA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto Filter question | Excel Worksheet Functions | |||
Auto filter through the Comman Button | Excel Worksheet Functions | |||
Is there a way to link Auto Filter values to a Cell | Excel Worksheet Functions | |||
Auto Filter - Protected sheet/workbook | Excel Discussion (Misc queries) | |||
Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions |