+ Reply to Thread
Results 1 to 3 of 3

How to Check a list of names?

  1. #1
    Registered User
    Join Date
    11-11-2011
    Location
    Anchorage, AK
    MS-Off Ver
    Excel 2011
    Posts
    2

    How to Check a list of names?

    So I have two lists of names. I need to find a way to remove, or mark so I can remove, the names that are in column one that are ALSO in column two.

    So the first list is like:

    karen
    janet
    francis
    angus
    elizabeth
    daniel
    brendan

    and the second is:

    karen
    brendan
    jonah
    angus
    elizabeth
    bethany

    So I would want to see in the end only the names that are original to the first list? So:

    janet
    francis

    HOW CAN I DO THIS??

    Thanks

  2. #2
    Valued Forum Contributor
    Join Date
    05-23-2011
    Location
    Lahore PK
    MS-Off Ver
    Excel 2007, 2013
    Posts
    627

    Re: How to Check a list of names?

    use vlookup or match fuction in the next cell of the name in a list. It will identify the name also appear in second list. then delete the common names
    Azam
    If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
    For prompt answer, be descriptive, concise, short, direct, and to-the-point.

  3. #3
    Registered User
    Join Date
    11-11-2011
    Location
    Anchorage, AK
    MS-Off Ver
    Excel 2011
    Posts
    2

    Re: How to Check a list of names?

    Thanks, that was just the function I needed!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1