Problem with Filters

[best401]

Hi,

I brought you an excel spreadsheet with the problem. I need to see if the Invoice number is repeated, so we use Filter to see how many times it was entered. Somehow there are certain invoices # that are in the spreadsheet but when you look for them at the displayed list from the filter, they are not there. I though it was from certain line but I was wrong. For example if you search the invoice # 317403, it is at the column F row 1131, but if you display the Filter, you won't see it.

[mdbct]

It appears that the first 1028 unique items will be on the drop down list. You can use the (Custom...) option if you know the invoice number.

[lecxe]

Hi best401

According to the specs the maximum number of unique values in the filter dropdown is 10000 in excel 2007 and 1000 in previos versions.

Notice that this number refers to the visible values and so you can easily see more if you use an auxilliary field in the filter where you create sub-categories.

[best401]

Yes, we have 2003.... thanks for your help...