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?