Search Criteria in Advanced Filter stops working with multiple rows

[mobilismx]

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. The results are in column G. If my Search Criteria is only 1 value, the result is correct, i.e., the address is filtered out. But if I add two rows or more, then none get filtered out, as shown below.

How do I fix this? Thanks in advance for your help.

[#2 · Accepted solution]

@mobilismx 

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.

[#3]

Going through this doc would help@mobilismx 

https://support.office.com/en-us/article/filter-by-using-advanced-criteria-4c9222fe-8529-4cd7-a898-3...

[#4]

@Sergei Baklan  thank you. That did it.

[#5]

@mobilismx , you are welcome, glad to help