Detectiveclem
Active Member
- Joined
- May 31, 2014
- Messages
- 320
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
Can anyone assist?
I have First names entered in Column B [B2:B5000] and their Surname in Column C [C2:C5000]. Let’s call this data set A
I have copied from another spreadsheet a list of First names in Column D [D2:D5000] and their Surname in Column E [E2:E5000]. Let’s call this set B.
I need to find where the data held in Set A exactly matches the data held in Set B and highlight the match (possibly using Conditional Formatting, but happy to be advised).
For the sake of clarity this is the type of data I am trying to match
SET A SET B
Any help really appreciated.
Thank you
I have First names entered in Column B [B2:B5000] and their Surname in Column C [C2:C5000]. Let’s call this data set A
I have copied from another spreadsheet a list of First names in Column D [D2:D5000] and their Surname in Column E [E2:E5000]. Let’s call this set B.
I need to find where the data held in Set A exactly matches the data held in Set B and highlight the match (possibly using Conditional Formatting, but happy to be advised).
For the sake of clarity this is the type of data I am trying to match
SET A SET B
| A | B | C | D |
1 | FIRST NAME | SURNAME | FIRST NAME | SURNAME |
2 | John | White | Kim | White |
3 | Alice | White | Giacinta | Brown |
4 | Tom | Brown | John | White |
5 | Giacinta | Green | Masamo | Green |
Any help really appreciated.
Thank you