When you want to know what values are common in 2 or more columns, highlighting the duplicate values is the best way to see them visually.
In this article, we will learn how to highlight duplicate values in two or more columns
Highlight Duplicate in Two or More Ranges
Here, I want you to highlight duplicate in ranges A1:A10, C2:C5 and D1:D6. Follow these steps:
(Or you can use ALT>H>L>H>D>ENTER sequential shortcut to highlight duplicates)
You can see each duplicate value highlighted by a color.
It is damn easy to highlight duplicate values in excel. Isn’t it? But if you have any question regarding this topic or any other, feel free to ask it in comment section below. I love to interact with excel users like you.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.