I have two columns of names. I want to find if there are any common names in
these two columns, and if there are I want to figure out which ones are
common. The only solution I could think of so far is using the find function
in Excel by entering each name individually from the second column and
searching them in the first column. It works, but considering the fact that
I have more than 250 names in the second column and 990 names in the first
one, I just wanted to know if there is a simpler way. I also have the SSN of
these individuals as separate columns, in case I might need numerical data
for comparison, instead of text. I am using Excel 2002.