Hello,
Looking for a formula to make this task easy!
If for example I have duplicate values in Column A, I wish to then find the corresponding duplicate values on another column, highlight these.
So, if column A had
Column A Column B
Dog brown
Dog Brown
Dog Grey
Cat White
rabbit White
I wish the 1st two columns highlighted!
I hope this helps!
Bookmarks