Are you looking for entire rows that are exactly the same? select the total range and click on Remove Duplicates in the Data menu