← Guides

Remove Duplicates in Excel

Built-in tool

  1. Select the data range (or Table)
  2. Data → Remove Duplicates
  3. Choose columns that define uniqueness
  4. OK
This permanently deletes rows. Copy the sheet first if you need a backup.

Dynamic array (source stays intact)

=UNIQUE(A2:C100)
=UNIQUE(A2:A100)

If #SPILL!, clear the output area — SPILL fix.

Error directory