Identify Duplicates

 

Trick To Identify Duplicates Values In Excel.

The Microsoft Excel COUNTIF Function helps you to identify duplicates in a data range.
To Identify duplicates you can using the following formula : -

=COUNTIF($A$3:$A$10,A3)>1

Also you can identify the duplicates using Conditional formatting in Microsoft Excel, But  Conditional formatting will identify the duplicates all values like If you have 3 duplicates values in a data range that will identify all values. And  The formula will keep 1 value as Non duplicate value  and identify 2 value as duplicates.

Learn More