Sep 21 2020 04:13 AM
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.
Sep 21 2020 04:32 AM
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.