Duplicates finding

Those who frequently use Excel sometimes have an issue with duplicate finding. LetТs look at example which shows how we can quickly highlight the duplicates by color.

Suppose, we have such table with list of loans which can repeated:

Duplicates finding

We have to check the duplicates. For this, select column УAФ and choose menu Main Ц Conditional formatting Ц Highlight Cells Rules Ц Duplicate Values...:

Duplicates finding

Press OK and will get needed result:

Duplicates finding

Also, at the last step we can choose Unique Values instead Duplicate and then will be colored only records which occur once.