How to Find and Remove Duplicates in Excel | 4 Methods

Are duplicates in your spreadsheets driving you crazy? I’ve got the perfect solution! In this video, I’ll show you 4 simple methods to identify and eliminate those pesky duplicates, whether they’re in a single column or across entire rows. I’ll walk you through each step, ensuring you can clean up your data with ease. Join me and learn how to tackle duplicates head-on, making your Excel experience smoother and more efficient.

00:00 Introduction
00:37 Highlight Duplicates in One Column
02:17 Highlight Entire Row Duplicates
06:34 Remove Duplicates Button
09:31 Remove Duplicates with UNIQUE Function
10:50 Remove Duplicates with PowerQuery

[CandisSarwan]

You are a fantastic teacher! Keep up the great lessons and good work.

[veruscrt]

I was the first student to arrive to study and felt very happy.

[Gigiknits]

Oh i didn't know power query could be refreshed this quickly on such a sheet (i know very little about power query, the tutorial i tried didn't vibe with my version of excel).

Very good tutorial as always!

I set up a report that finds duplicate orders for my colleagues, so they have a lot less hassle with unhappy customers now.

I created a report that goes through our open orders and finds duplicate order numbers. If this happens, i get an alert, and an email. It rans constantly on a spare pc, and about once a day there is something wrong. And if there is something wrong, i find out very quickly and we don't ship the stuff. It works with countif i think. My colleagues think I'm some kind of all knowing genius 😂 and it just runs by itself.