+ Reply to Thread
Results 1 to 5 of 5

Comparison of Values based on pattern Matching

  1. #1
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    180

    Red face Comparison of Values based on pattern Matching

    Hi All,

    I have to match values in two columns based on the similarities ...Can you please help me here...Attached the sheet...Column C has the matched answer as yes or no...Can you please help me here..




    Thanks,
    Arun
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    18,396

    Re: Comparison of Values based on pattern Matching

    What rules are to apply:

    tsobel SOBELT exact match on letters
    mpetrizzi PETRIZZIM " "
    jburford5 BURFORDJIM Partial match (ignoring numerics and IM)
    jschwartz20 SCHWARTZJ Match ignoring numerics

  3. #3
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    180

    Re: Comparison of Values based on pattern Matching

    Hi John,

    There are two rules that I observe:

    1) the last character is placed at the beginning from the first column for matching..
    2) Based on similarity of characters (more than 75% similarity )results in a match or matching based on sounds (how the values based in the two columns sound like)..

    Thanks,
    Arun

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    18,396

    Re: Comparison of Values based on pattern Matching

    Unfortunately, Excel does not do "sounds" !

    But for Case !.

    =IF(LEFT(A2,1)=RIGHT(B2,1),"Yes","No")

    Fails for ..

    jburford5 BURFORDJIM

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    18,396

    Re: Comparison of Values based on pattern Matching

    Slightly more comprehensive

    =IF(AND(LEFT(A2,1)=RIGHT(B2,1),MID(A2,2,LEN(A2)-1)=MID(B2,1,LEN(A2)-1)),"Yes","No")

+ 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. [SOLVED] Rotation Pattern based on the Pattern String for scheduling tasks
    By qadeerume in forum Excel General
    Replies: 8
    Last Post: 08-11-2020, 11:49 PM
  2. Reg replacing cell values based on a pattern
    By sam9989 in forum Excel General
    Replies: 5
    Last Post: 03-18-2018, 10:26 AM
  3. Macro to insert pattern based on value and select based on pattern
    By CB569 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-15-2015, 12:36 PM
  4. [SOLVED] Lookup and return rows based on pattern start and pattern end
    By JDI in forum Excel General
    Replies: 18
    Last Post: 11-16-2014, 11:44 PM
  5. Replies: 1
    Last Post: 04-23-2013, 12:46 AM
  6. Need a new regex .pattern for comparison code
    By Swiss Cheese in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-06-2012, 09:16 PM
  7. Compare 2 values and then assign a 3rd based on comparison
    By Mordred in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-10-2010, 02:22 PM

Tags for this Thread

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