Forum Discussion
Solved
Highlight Duplicates but only from one column
Hello, I have two columns of values in my screenshot. Column D and Column E. Column D has some duplicates and Column E does not. How do look at both columns but only highlight the duplicates ...
Use MATCH() function. See the attached file.
Try this formula