I am working on something with genealogy.. I have copied and pasted into an excel.. and essentially I need to isolate potential duplicates.. there are thousands of names , so if I could somehow highlight these matches it would be great.
I delineated the data to separate first and last name.. anyway , I want to conditionally format so that it highlights them.. I'm just running into the issue that it will highlight everything that is a duplicate, but ..I need it to highlight first and last match ONLY.
Any suggestions would be much appreciated !!!!
Please see attached example.
THANK YOU !!!!