Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Autofilter Lists Problem
I have a spreadsheet that has 1576 rows and 30 columns. When doing spot
checks I switch on the Autofiler and use the drop down list to locate the specified value. In my spreadsheet in one column that I have labelled as "Lot" I am unable to locate the specified value. However, I can scroll down and see the value or I can use the CTRL+F function to find the value. So why am I unable to see the value through the AUTOFILTER drop down list when all rows are selected. This has become very frustrating so any help and advice would be great. I am unable to use the AUTOFILTER dropdown list anymore because I can't trust the results. |
#2
|
|||
|
|||
Autofilter will only display 1000 seperate items. One way round it is to use
another adjacent column with sub categories and filter by that column, then the original to keep under 1000 seperate items, Regards, Alan. "Medows" wrote in message ... I have a spreadsheet that has 1576 rows and 30 columns. When doing spot checks I switch on the Autofiler and use the drop down list to locate the specified value. In my spreadsheet in one column that I have labelled as "Lot" I am unable to locate the specified value. However, I can scroll down and see the value or I can use the CTRL+F function to find the value. So why am I unable to see the value through the AUTOFILTER drop down list when all rows are selected. This has become very frustrating so any help and advice would be great. I am unable to use the AUTOFILTER dropdown list anymore because I can't trust the results. |
#3
|
|||
|
|||
An AutoFilter dropdown list will only show 1000 entries. If your column
has more than 1000 unique items, they can be filtered, but they can't all be displayed in the dropdown list. To AutoFilter for an item that doesn't appear in the dropdown list, you can choose Custom from the dropdown list, and type the criteria. Also, there are a couple of workarounds he http://www.contextures.com/xlautofilter02.html#Limits Medows wrote: I have a spreadsheet that has 1576 rows and 30 columns. When doing spot checks I switch on the Autofiler and use the drop down list to locate the specified value. In my spreadsheet in one column that I have labelled as "Lot" I am unable to locate the specified value. However, I can scroll down and see the value or I can use the CTRL+F function to find the value. So why am I unable to see the value through the AUTOFILTER drop down list when all rows are selected. This has become very frustrating so any help and advice would be great. I am unable to use the AUTOFILTER dropdown list anymore because I can't trust the results. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Strange autofilter problem | Excel Discussion (Misc queries) | |||
Excel AutoFilter Problem | Excel Discussion (Misc queries) | |||
autofilter problem | Excel Worksheet Functions | |||
Problem with VLOOKUP and drop-down lists! | Excel Worksheet Functions | |||
New Project, Different Problem: AutoFilter? | Excel Discussion (Misc queries) |