How to analyze worksheets for duplicate records and highlight/remove them
Term duplicates is applicable to the tables with database structure. It means records which are the same by specific criteria. You can use different criteria to define which records you treat as "identical".
The most common cases:
Described cases are applicable to single worksheet - filter database table and remove duplicates and two worksheets - compare records in 2 excel sheets and exclude duplicates.