Extract unique items from a list in excel – 06 Techniques

In this tutorial learn 06 techniques including Excel tools and Formula to extract unique items from a list in excel. The formula includes a combination of COUNTIF, IF, N, INDEX, and MATCH functions to create a dynamic unique item list.

You can navigate on specific topics following the time stamps below.

⌚ Timestamps

0:00 Introduction
0:35 Remove Duplicates
2:35 Advanced Filters
4:18 Pivot Table
6:46 Power Query
09:07 Formula with helper column
14:58 Smart Formula
17:43 Conclusion

Watch related Microsoft Excel playlists

🚩 Let's connect on social

🔔 Subscribe to my YouTube channel