Thread
:
Comparing two Non- Identical Columns of Data
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett