Comparing two Non- Identical Columns of Data
 

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

Comparing two Non- Identical Columns of Data
 

try

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RBG" wrote in message
...
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

Comparing two Non- Identical Columns of Data
 

works great...thanks.....

"Don Guillett" wrote:

try

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RBG" wrote in message
...
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