8 Ways To Find & Remove Duplicate Values In Excel

Опубликовано: 15 Февраль 2025
на канале: How To Excel

155,673

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/... 👇

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:   / howtoexcelblog
Twitter:   / howtoexcelblog
LinkedIn:   / john-macdougall

Thanks for all your support!