Excel can strip out duplicate rows in one click, or you can flag duplicates with a formula if you want to review them first.
Do it with AI insteadSelect your data
Click any cell in the table, or select the exact range you want to dedupe.
Open Remove Duplicates
Go to Data ▸ Remove Duplicates.
Choose the key columns
Tick the columns that define a duplicate, then click OK. Excel reports how many it removed.
Yes — Excel keeps the first row and removes the later duplicates.