# Comparison of Values based on pattern Matching

Hi All,

Thanks,
Arun

2. ## 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. ## 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. ## 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. ## 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")

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