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? :confused:

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

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

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? :confused:

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