Can't attach the file or an extract for various reasons, which might make this impossible to answer.
Have a spreadsheet with column containing dates in Sept, Oct and Nov.
When I applied the "filter", the Drop List contains only Sept and Oct.
There are no "blanks" in the filled range, and no evidence of Macro or formula limiting the filter.
Never seen this before, so hope someone can provide an insight?
Ochimus
Bookmarks