How to Remove Duplicate Rows in Excel

Apply below given the formula to remove duplicate rows in Excel:

=IF(MAX(COUNTIF(A1:A3306,A1:A3306))>1,"Duplicates","No Duplicates")

A1 is the Column, change to any column based upon your Excel Spread Sheet.

A3306 is the range of rows, change it your range of rows, it could be 100 or 200 or more depends upon the number of rows.

Rest, keep it default, and apply the formula next to the all rows and the duplicate rows will appear.

Cheers!!!