Extract identical cells of 2 columns (excel)

Little bit lost - Mar 30, 2009 at 12:05 PM
 keliza - Mar 2, 2010 at 10:14 PM
Hello helpers!,

Got a list of words in column A
Got a list of words in column B
I am looking for a formula that will produce in column C a list of the words that appear on both columns.

Thank you for your help!

2 responses

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Apr 13, 2009 at 11:49 AM
Put the following formula in cell C1 and drag down
I have two tables of names and adderesses. The first table is in sheet 1, the second table is in sheet 2. The names are in column A of each table, starting at A1. Each table has data in rows A to E.

I want to compare the names in column A of each table, then have the matches copied to Sheet 3, with the names in Column A.

Are you able to help?