Forum Discussion
Solved
Search Criteria in Advanced Filter stops working with multiple rows
I want to filter several email addresses out of a list. I am using Advanced Filter to copy the desired values into a new column. My original list is in column C. The Search Criteria is in column E. T...
With not equal you shall use AND condition, other words copy E1 to F1 and E3 to F2 and use E1:F2 as criteria.
For OR condition put addresses in different rows, e.g. one to E2, another to F3 and E1:F3 as criteria range, header in E1 and F1 is the same.
