View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RBG RBG is offline
external usenet poster
 
Posts: 9
Default 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