BradleyS
Active Member
- Joined
- Oct 28, 2006
- Messages
- 333
- Office Version
- 2010
- Platform
- Windows
Hi
I don't actually know if this is possible, but here goes.
I have two spreadsheets in the same workbook that have similar contents (i.e. Surname, Forename and Date of Birth)
Now some names will appear on both sheets.
I would like a list of those that appear on both sheets (on a separate sheet) and a list of those that aren’t on both sheets.
Can this be done in Excel and if so what formula should I be trying to use?
Your help would be most appreciated.
I don't actually know if this is possible, but here goes.
I have two spreadsheets in the same workbook that have similar contents (i.e. Surname, Forename and Date of Birth)
Now some names will appear on both sheets.
I would like a list of those that appear on both sheets (on a separate sheet) and a list of those that aren’t on both sheets.
Can this be done in Excel and if so what formula should I be trying to use?
Your help would be most appreciated.
