nav2567
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.