View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
IFIXPCS
 
Posts: n/a
Default Comparing 2 list

I have read through alot of problems here in the forum but none have answered
mine.

I am wanting to compare 2 columns for exact matching (ex. "Green32"). And
if there are two matching items I want to be able to say "A match" in a
chosen cell for all the ones that match.

Example:
A B C
45time 89time
A match 11tune 11tune
47doog 43jkjkj
A match 123ABC 123ABC

please help!!

Thank you in advance!