BradleyS
Active Member
- Joined
- Oct 28, 2006
- Messages
- 324
- 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.
