Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop-down lists
I am trying to search through a list that is 12 columns wide by 8912 rows. Each row must stay together. The spreadsheet I have now has drop-downs on the top of the page, but the drop-down lists do not include all the possible entries in each column. It only contains approximately 1000 of the first alph-numeric entries. Is there a 1000 entry limit on drop-down lists? How can I get the drop-downs to include all data in the column? Thanks for any and all help on this.:) -- prodrafter ------------------------------------------------------------------------ prodrafter's Profile: http://www.excelforum.com/member.php...o&userid=30287 View this thread: http://www.excelforum.com/showthread...hreadid=499557 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop-down lists
Yes, there is a limit of 1000 unique values in a filter drop-down list.
You can use Custom, Greater Than ... to see more values above these, but these are not individually filterable. If you use another (temporary ?) column, you can devise ways of categorising the data to enable yo to see more. For example, if you want to filter numeric values, then in your helper column you could have a formula: = INT(A1/1000) and this would then aggregate values into thousands. A column of text values could have the formula: =LEFT(A1,1) applied to it, thereby aggregating under initial letter. By filtering the helper column first, you can then filter the column which you are really interested in. Hope this helps, Pete |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop-down lists
From the AutoFilter dropdown list in the column heading, select Custom
In the first dropdown list, choose Equals In the text box, type the entry you want to find Click OK Or, use one of the workarounds that Pete mentioned. There's an example he http://www.contextures.com/xlautofilter02.html prodrafter wrote: I am trying to search through a list that is 12 columns wide by 8912 rows. Each row must stay together. The spreadsheet I have now has drop-downs on the top of the page, but the drop-down lists do not include all the possible entries in each column. It only contains approximately 1000 of the first alph-numeric entries. Is there a 1000 entry limit on drop-down lists? How can I get the drop-downs to include all data in the column? Thanks for any and all help on this.:) -- 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 | |||
Drop Down Lists | Excel Worksheet Functions | |||
unrestricting drop down lists | Excel Worksheet Functions | |||
Data Validation - Drop down lists - if then? | Excel Discussion (Misc queries) | |||
multiple drop down lists | Excel Discussion (Misc queries) | |||
Can different drop down lists be displayed depending on the value. | Excel Discussion (Misc queries) |