COMPARING TWO COLUMNS OF NAMES IN EXCEL [Solved/Closed]
STEMPEKA - Latest answer on Apr 16, 2013 06:33PM
I have one excel sheet. column A has a list of names formated as follows:
Last name, First name
column B has a much longer list o names in the same format.
Some of the names in column A exist in column B.
I am looking for a formula that will produce in column C the names that appear on both lists.
Thanks for your help!!!