Advanced filtering

%3CLINGO-SUB%20id%3D%22lingo-sub-1690897%22%20slang%3D%22en-US%22%3EAdvanced%20filtering%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1690897%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20with%20two%20columns%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-Colomn%20A%3A%20A%20list%20of%203500%20e-mail%20adresses%3CBR%20%2F%3E-Column%20B%20%3A%20A%20list%20of%20600%20e-mail%20adresses%20(feedback%20from%20a%20online%20questionnaire%20based%20on%20addresses%20in%20column%20A)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20filter%20out%20a%20total%20list%20of%20e-mail%20addresses%20based%20on%20column%20A%20which%20exclude%20the%20e-mail%20addresses%20in%20column%20B.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1690897%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1690986%22%20slang%3D%22en-US%22%3ERe%3A%20Advanced%20filtering%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1690986%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F798551%22%20target%3D%22_blank%22%3E%40aelinnestad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20add%20helper%20column%20C%20with%20formula%20in%20A1%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DCOUNTIF(B%3AB%2CA1)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Edrag%20it%20till%20end%20of%20the%20range%20in%20column%20A%20and%20filter%20on%20column%20C%20selecting%20only%20zero%20in%20filter.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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.

 

3 Replies
Highlighted

@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.

@Sergei Baklan Perfect, thanks!

Highlighted

@aelinnestad , you are welcome