Creating unique lists in Excel with the tool “Remove Duplicates”

Do you need to extract a Unique List of entries from a specific dataset? You can do so by using the tool “Remove Duplicates” and this video will show you exactly how to do that. In addition to extracting a single list of values, you will also learn how to extract a combined list of unique values so you can boost your analysis. Finally, this video will also cover some important math and statistical functions you can apply to the unique lists you create.

Unique Lists - Intro 0:00
Creating a Unique List (Example 1) 0:38
Applying Functions to a Unique List (Example 1) 3:26
Single Unique List (Example 2) 4:54
Applying Functions to a Unique List (Example 2) 6:46
Combined Unique List (Example 3) 8:27
Applying Functions to a Combined List (Example 3) 9:49
Bonus Tip on Unique Lists 12:06
Final Thoughts 13:20

Download the Excel file used in this video:

Do you want to succeed in Excel? Enroll today at my course Excel Master:

How good are you with Data Analysis in Excel? Take our quiz to find out: