Excel Magic Trick 1098: Compare Two E-mail Lists with Formula: E-mail In List? Not In List?




About this tutorial:

Video duration: 5:14
Download Excel File:

See how to compare two e-mail lists where one list has extra semi-colons:
1. (00:28 min) Find and Replace feature to remove semi-colons (Ctrl + H).
2. (01:32 min) Is in List: MATCH and ISNUMBER functions.
3. (03:20 min) Is NOT in List: MATCH and ISNA functions.

Compare Two Email Lists. Is Email in List? Is email NOT in List? Compare 2 E-mail Lists. Is E-mail in List? Is e-mail NOT in List?

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

9 thoughts on “Excel Magic Trick 1098: Compare Two E-mail Lists with Formula: E-mail In List? Not In List?

    Naomi Madelin

    (March 25, 2019 - 2:49 am)

    Thank heavens! Finally someone who can show me reliably and clearly how to do this. Yay! You saved my day. Thank you. So many mangled instructions out there that over-complicate this.

    Tanya Kucey

    (March 25, 2019 - 2:49 am)

    Did work for me at all. Maybe needs an update for Xcel online? But thanks for puting ths out there

    J L

    (March 25, 2019 - 2:49 am)

    I need help on another subject how can i go about getting help from you?

    Kevin V

    (March 25, 2019 - 2:49 am)

    Thanks! You are making the world a better place

    Lun Fai Tang

    (March 25, 2019 - 2:49 am)

    Thank you!

    ExcelVbaIsFun

    (March 25, 2019 - 2:49 am)

    Thanks for the video. What a great use of MATCH. I find myself being a little too VLookup dependant. Thanks for bringing me back to balance! Appreciate the lessons and clarity that you present! Dan

    krn14242

    (March 25, 2019 - 2:49 am)

    Thanks Mike

    ExcelXL.nl

    (March 25, 2019 - 2:49 am)

    Thank you!

    ExcelIsFun

    (March 25, 2019 - 2:49 am)

    Excel Magic Trick 1098: Compare Two E-mail Lists with Formula: E-mail In List? Not In List? 

Leave a Reply

Your email address will not be published. Required fields are marked *