Link to home
Start Free TrialLog in
Avatar of nav2567
nav2567Flag for United States of America

asked on

compare column in an Excel spreadsheet.

Hello,

I have a Excel spreadsheet which has the following layout:

Column A     Column B
name1          name3.mydomain.com
name2          name5.mydomain.com
name3          name1.mydomain.com

I need to put the word "Match" in column C if name in Column A in found in Column C

Column A     Column B
name1          name3.mydomain.com      MATCH
name2          name5.mydomain.com
name3          name1.mydomain.com      MATCH

Please advise a formula to do it.  

Thanks.
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial