Related:
- Excel intersection of multiple columns
- Excel drop down list multiple columns - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Split excel sheet into multiple files - Guide
- Excel column number - Guide
- Vat calculation excel - Guide
2 responses
Excelguru
Posts
261
Registration date
Saturday 11 April 2009
Status
Member
Last seen
21 June 2011
307
13 Apr 2009 à 11:49
13 Apr 2009 à 11:49
Put the following formula in cell C1 and drag down
=IF(COUNTIF($B:$B,A1)>=1,A1,"")
=IF(COUNTIF($B:$B,A1)>=1,A1,"")
2 Mar 2010 à 22:14
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?
Thanks,
Keliza