Help finding duplicates

That's a really good solution , I can merge those two columns and then highlight the duplicates by conditional formatting.
Thank you very very much!

Originally Posted by Shift-4

I would use concatenate and then remove duplicates function on the column I concatenated.



Edit: oops, read that wrong. I thought you wanted them deleted.

That's a really good solution , I can merge those two columns and then highlight the duplicates by conditional formatting.
Thank you very very much!