7 different methods to create a Unique List of Records, in other words, 7 different methods to Remove Duplicates in Excel are explained in this video.

Intro (0:00)
1. Remove Duplicates Tool (0:41)
2. Advanced Filter (1:36)
3. IF and COUNTIF Functions (2:33)
4. UNIQUE Function (4:36)
5. Macro to Remove Duplicates (5:09)
6. Pivot Table (6:00)
7. Power Query (8:18)
8. Outro (9:51)

If you’ve found my videos helpful or enjoyable, consider supporting me with a coffee!
buymeacoffee.com/ajayanand

Top 25 Microsoft Word Tips and Tricks - https://youtu.be/l25Evu4ohKg
7 Most Important Tools in Excel - https://youtu.be/Pc88LGWNO70
Download my free eBook on Excel Macros - http://eepurl.com/gpT0RD
Check these Books on Excel - https://xlncad.com/excel-resources/
Read my articles on Excel - https://xlncad.com/

#removeduplicates #exceltutorial #excelforbeginners