Comparing two Non- Identical Columns of Data

R

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
 
D

Don Guillett

try

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