+ Reply to Thread
Results 1 to 1 of 1

Search two LISTS (columns A and B) to find common matches (which may not be EXACT matches)

  1. #1
    Registered User
    Join Date
    08-11-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Search two LISTS (columns A and B) to find common matches (which may not be EXACT matches)

    Hi Excel Guru's!

    Long Story Short - I need to find similarities between two columns of names which may be formatted slightly differently.

    Goal: to find out which company contacts (COLUMN A - see attached) will be at a conference (COLUMN B - see attached).

    The attached is obviously just an example illustrating the issue I'm having.

    As you can see, I have put some of the same companies in Columns A and B, but the names do not match up exactly. This is the biggest problem.

    Could you advise as to what to do or which functions to use to search two (RATHER LARGE) lists quickly to find similarities?

    Thanks in advance!!
    Attached Files Attached Files

+ 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