8 Ways To Find & Remove Duplicate Values In Excel

Learn 8 ways to find and remove duplicate values from your data so you can keep the unique values.

Table of Contents
1. Remove duplicates command in the ribbon 0:26
2. Advanced filters 1:42
3. Pivot tables 3:25
4. Power query 5:06
5. Excel formulas 7:28
6. Conditional formatting 11:12
7. VBA code 12:35
8. Dynamic Arrays 14:34

Get the workbook used in the video to follow along. https://howtoexcel-my.sharepoint.com/:x:/g/personal/john_howtoexcel_onmicrosoft_com/EY44smRzKFRPhst0p4FIOpIBa-u4h_aaPWAyR0VIXLjT4Q?e=f1xDel 👇

Check out my full courses and ebooks here
👉 https://www.howtoexcel.org/courses/

DOWNLOAD the example workbook here
📖 https://www.howtoexcel.org/downloads/

SUBSCRIBE & get my 3 FREE eBooks
📧 https://www.howtoexcel.org/newsletter/

CONNECT with me on social
Facebook: https://www.facebook.com/howtoexcelblog
Twitter: https://twitter.com/howtoexcelblog
LinkedIn: https://www.linkedin.com/in/john-macdougall/

Thanks for all your support!

Видео 8 Ways To Find & Remove Duplicate Values In Excel канала How To Excel