Advanced filtering

[aelinnestad]

I have a spreadsheet with two columns:

-Colomn A: A list of 3500 e-mail adresses
-Column B : A list of 600 e-mail adresses (feedback from a online questionnaire based on addresses in column A)

I would like to filter out a total list of e-mail addresses based on column A which exclude the e-mail addresses in column B.

[#2]

@aelinnestad 

You may add helper column C with formula in A1 

=COUNTIF(B:B,A1)

drag it till end of the range in column A and filter on column C selecting only zero in filter.

[#3]

@Sergei Baklan Perfect, thanks!

[#4]

@aelinnestad , you are welcome