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!!!