Detectiveclem
Active Member
 Joined
 May 31, 2014
 Messages
 277
 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