hellor,

Well, i hope someone here will be able to help me!

My data is as follows:

LAST NAME FIRST NAME

1. ABC OPP
2. XYZ MGF
3. RTY SED
4. QRS WER
5. ABC OPP
6. RTY SED
7. QFG CVT
8. POL MUH


I want to identify the duplicate entries by grabbing the data from both
columns that is Last Name and First Name as well.
So that I get rows 1 &5 as well as rows 3 &4 highlighted.

All the help information that you have given in the community is for data in
ONe COLUMN ONLY.
You will be of great help if you could add a solution to my problem as well!

Looking forward to your reply