+ Reply to Thread
Results 1 to 2 of 2

Find Partial Text Match between Two Columns of data

  1. #1
    Registered User
    Join Date
    10-23-2013
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2007
    Posts
    1

    Find Partial Text Match between Two Columns of data

    Hi Everyone,

    I am relatively new to Excel. I am in the process of comparing two columns of data to determine whether the data in each column relate. Column A has the key name from one product in one system and Column B has the key name from the same product in another system. There are 55,000 rows of key names to go through and I would really like to find an easier way to compare then than just doing it by eye. The key names don't have to match exactly they just have to be similar. For example,

    COLUMN A:
    Bourbon Seagram BTL
    SS Bailey's
    Vodka Skyy BTL
    SS House Rum

    COLUMN B:
    BTL Seagram
    Bailey
    BTL Skyy
    Vodka (Column C would show that this doesn't match Column A)

    Is there an easier way to go through the two columbs and find cells that don't match at all? Please help!!!


    Thanks,

    Samybelen
    Last edited by samybelen; 10-23-2013 at 01:43 PM.

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2211 (Build 15813.20002) Win 11 Home 64 Bit
    Posts
    22,131

    Re: Find Partial Text Match between Two Columns of data

    Here are two links that might be helpful:

    http://www.excelforum.com/excel-tips...for-excel.html

    http://www.mrexcel.com/forum/excel-q...planation.html
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to compare partial match in two columns
    By santosh.themagic in forum Excel General
    Replies: 4
    Last Post: 08-19-2013, 08:09 AM
  2. Partial IP Address Range Match Between 2 Columns
    By RickT in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-06-2013, 11:40 AM
  3. Replies: 3
    Last Post: 01-28-2012, 03:41 PM
  4. Replies: 20
    Last Post: 01-02-2011, 10:00 PM
  5. How to compare partial match in two columns
    By martinaquan in forum Excel General
    Replies: 2
    Last Post: 08-25-2010, 02:15 PM

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