Hi Guys,
I am really struggling with a problem and hope someone out there will be able to help me.
I have a worksheet containing two columns with approx. 1000 company names on each column.
Example:
Column 1
apple
jp morgan
etc
I have one more column to the right of column 1 named column 2
I need to compare the two rows so I can eliminate the names on column 1 that duplicates with column 2
So when I am done I can see which companies that exist in column 1, and not in column 2.
I appreciate all the help I can get
Many many thanks!
Bookmarks