Duplicates in your data can completely undermine your work. In this video I'll cover the 7 ways you can identify, and or remove duplicates in Excel. You can watch them all and choose the one right for your task, or use the time stamps in the video description to jump to the method you want.

DOWNLOAD EXCEL FILE HERE: https://www.myonlinetraininghub.com/e...

LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/

SUBSCRIBE if you’d like more tips and tutorials like this.

Please leave me a COMMENT. I read them all!

‍♀ CONNECT with Mynda on LinkedIn:   / myndatreacy  

SHARE this video and spread the Excel love.

Or if you’re short of time, please click the

EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/e...

⏲ TIMESTAMPS
0:00 How to Remove Duplicates in Excel
0:36 Highlight Duplicates with Conditional Formatting
1:38 Identify Duplicates with Formulas
2:43 Identify Duplicates with PivotTables
3:50 Extract a distinct list with UNIQUE
4:33 Remove Duplicates Tool One Time
5:43 Remove Duplicates with Power Query Many Times
7:16 Remove Duplicates with Advanced Filter One Time
8:17 Summary & File Download Link