Results 1 to 5 of 5

How to compare text of same row in two different columns and return matching words?

Threaded View

  1. #1
    Registered User
    Join Date
    08-14-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2016
    Posts
    32

    How to compare text of same row in two different columns and return matching words?

    Hi,
    I need to compare two very long lists of company names. I wish to compare the name in col A with the name in the same row in col B and return the matching words in the same row in C. I have tried Fuzzy Lookup Add-in but somehow it does not work in Excel 2007.

    The sample is attached with indicative results given in column C.

    Any help will be highly appreciated.

    Best regards,
    guest
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Compare columns and finding matching values/text
    By debake in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-02-2014, 09:27 AM
  2. Replies: 0
    Last Post: 10-07-2013, 10:24 AM
  3. Replies: 2
    Last Post: 07-17-2013, 11:48 AM
  4. Replies: 1
    Last Post: 04-21-2013, 08:36 AM
  5. [SOLVED] Find matching words in 10 columns and add row numbers of matching words
    By zeke 29 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-03-2012, 09:57 AM

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