Related:
- Excel intersect two columns
- Display two columns in data validation list but return only one - Guide
- Excel marksheet - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Dash becomes date on excel ✓ - Office Software Forum
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
Apr 13, 2009 at 11:49 AM
Put the following formula in cell C1 and drag down
=IF(COUNTIF($B:$B,A1)>=1,A1,"")
=IF(COUNTIF($B:$B,A1)>=1,A1,"")
Mar 2, 2010 at 10:14 PM
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