How to use Excel : How to find duplicates in Excel

How to identify duplicates in Excel

Using COUNTIF function is the easiest way to find the duplicates in a excel.

Here is the formula to identify the duplicates

=COUNTIF(B:B,B2)>1
Input the above formula in C2, then select C2 and drag to fill the formula down to other cells.

Please visit other related articles

How to use Excel: How to find duplicates in Excel
How to use Excel: How to set default font in MS EXCEL?
How to use Excel: Sorting and filtering in Excel
How to use Excel: Excel formula guide for beginners