I’m trying to do an advanced filter, filtering out all the transactions of 4 account numbers from a large list of many customers. Using a regular Custom filter, I can only filter out 2. Using the advanced filter, I tried to use the <> operator to tell it which 4 not to look for, but it’s a logical inconsistancy. If your account numbers are 20111, 20745, 78987 and 54012, the first time you tell it <> 20111, it automatically includes the others.
How can I filter more than 2 of any given criteria?