I´m trying to filter a list to exclude certain elements, but show everything else. Since I have 4 criterias, i guess advanced filter is the way to go -when i get it working, it will be recorded as a macro.
Question is; why does it only work with one <> condition? If I use the normal =somevalue, =somevalue2 etc, it filters from criteria range as it should.
The names in the list can vary, and so can the number of items on the list (comes from a text file), but the ones i want to exclude is always present, and unfortunately not always in the same row