Excel Roadmap
The lesson player with the free lesson Your first pivot table in the practice Excel: a pivot table of revenue by region, the PivotTable Fields pane beside it, and the lesson panel with the step "Drag Revenue into Values" checked.
How a lesson looks on a computer.

Confident · 9 min · 13 steps · checked as you go

Remove duplicates

Delete repeated rows from a merged list, and choose which columns decide what counts as a duplicate.

Do this lesson on your computer.

It runs beside a practice Excel in your browser, and every step is checked as you go. Free, with no sign-up.

On your computer, go tolearnford.com/go/2R5R

The full Excel course: 217 lessons, US$149.

Lifetime access, a practice Excel in your browser, and new lessons as we add them.

See the Excel course

In this lesson

  • Select the whole list, headers included, then Data, then Remove Duplicates.
  • A row is a duplicate when every ticked column matches an earlier row.
  • The first row from the top stays. Sort first if you want to keep the newest row instead.
Excel Roadmap

Not affiliated with Microsoft or Google.