drop-down lists

P

prodrafter

I am trying to search through a list that is 12 columns wide by 891
rows. Each row must stay together.

The spreadsheet I have now has drop-downs on the top of the page, bu
the drop-down lists do not include all the possible entries in eac
column. It only contains approximately 1000 of the first alph-numeri
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.:
 
P

Pete

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
 
Top