filter

[missy]

I have a filter set on a column but it is not sorting
correctly? I have tried deleting and applying again but
it is doing the same thing.

 

[Guest]

Hi, missy;
Filtering and sorting are two different operations. Sort your column first
(there are only two options: ascending or descending), then apply your
filter. If this does not answer your question, give us more detail about what
you are trying to do.
Regards,
IanRoy

 

[Debra Dalgleish]

An AutoFilter dropdown list will only show 1000 entries. If your column
has more than 1000 unique items, they can be filtered, but they can't
all be displayed in the dropdown list. The items in the column appear
alphabetically sorted in the dropdown list, and only the first 1000
alphabetical entries will appear.

To AutoFilter for an item that doesn't appear in the dropdown list, you
can choose Custom from the dropdown list, and type the criteria, as
you're currently doing. Also, there are a couple of workarounds here:

http://www.contextures.com/xlautofilter02.html