Comparing two Non- Identical Columns of Data

[RBG]

I dont know if its possible via a formula in a third column, but I would like
to have a formula comparing Column 1 to column 2 to determine if the data
after the 'comma' in both columns are identical. Just not sure how...

Column 1 Column 2
Managing Director, Finance MD, Finance
Senior Vice President, Operations SVP, Operations

Thanks

 

[Don Guillett]

try

=IF(RIGHT(C14,LEN(C14)-FIND(",",C14))=RIGHT(D14,LEN(D14)-FIND(",",D14)),"match","")

 

[RBG]

works great...thanks.....

try

=IF(RIGHT(C14,LEN(C14)-FIND(",",C14))=RIGHT(D14,LEN(D14)-FIND(",",D14)),"match","")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)