Information missing in Auto Filter

**Chemistification** · 10-01-2009, 06:37 AM

I have a spread sheet with a list of product codes in one column. When i go to use the filter there are certain codes missing.

e.g.

BTP009
BTP010
BTP213
BTP345

and in auto filter BTP213 doesnt show. I have had a look at how it is written and it looks exactly like the other codes. THis happens on a few different codes. I have checked the cell formatting and its the same and also if there are any spaces or anything and can't find anything.

Could it be 8000 lines is too much for it to handle? There are quite a lot of different codes as well?

**Chemistification** · 10-01-2009, 06:41 AM

Ah i just tried looking into this and apparently there is a limit of 1000 unique entries for Auto Filter. I will split the sheet up and see unless anyone knows any neat tricks?

**DonkeyOte** · 10-01-2009, 06:42 AM

see: http://support.microsoft.com/kb/295971

You could use Advanced Filter perhaps ?

**martindwilson** · 10-01-2009, 06:43 AM

there is only a limit of what you see in the drop down the filter still works on more than 1000

**DonkeyOte** · 10-01-2009, 06:45 AM

yes, good point Martin.

**Chemistification** · 10-01-2009, 06:45 AM

Ok thanks both. Will give advanced filter a go. Never seen this problem before and just thought it was something with the way the data was entered.

Cheers for your help