Hi all,
I have a spreadsheet written by someone else, and I'm trying to do advanced filter (in a macro, but it doesn't work when done manually either) and the results don't match what the auto filter does. For example, auto filter using "contains FireSuppr" gives me three rows. Advanced filter returns 0 rows. This is true for some other filter words as well ("Site" gives me 29 rows with auto filter, and 26 rows with advanced filter).
I've tried retyping the words in the cells, both in the selection range and the criteria range and I'm running out of ideas.
demo.xlsx
Bookmarks