Home |
Search |
Today's Posts |
#1
|
|||
|
|||
EXCEL AUTOFILTER
Hello,
I have an Excel spreadsheet with 5657 records. When I use the autofilter feature to filter by, for example, the last name column I only receive 1586 records in the drop down box. What gives? |
#2
|
|||
|
|||
Hi
see: http://www.contextures.com/xlautofilter02.html#Limits -- Regards Frank Kabel Frankfurt, Germany "Aaron Neunz" schrieb im Newsbeitrag ... Hello, I have an Excel spreadsheet with 5657 records. When I use the autofilter feature to filter by, for example, the last name column I only receive 1586 records in the drop down box. What gives? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel Autofilter - limitations? | Excel Discussion (Misc queries) | |||
Windows search in Excel with autofilter | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
Using AutoFilter In Excel, I can't get Excel to recalculate only . | Excel Discussion (Misc queries) |