 # Yes, it's another Excel question

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?

Thanks!

StG

Set up another cell in your table, and have it default to a value of TRUE if the number is equal to any of your values, and FALSE if not. Formulas can be much more involved than filters. Then use your filter to filter out all rows where the new cell = TRUE

CrazyJoe’s solution is probably the best.

But, if you want to use an Advanced Filter it can be done with a logical formula as criteria.

Refer to this link and see the section “Criteria created as the result of a formula” and the example that follows it.

For your situation, you need a formula "=AND(A2<>20111, A2<>20745, A2<>78987,A2<>54012) where A2 is the first Account Number cell in your table