Category:

Course Description:

Your original data set contains multiple instances of the same entry but you’d like to have a drop-down list that only includes unique items in Excel? And you’d like to do this with an Excel formula? This video is for you. As a first step I use formulas to extract the list of unique items to separate cells. My method includes a combination of the Index function together with Match and the Countif function. I’ll show you a way to also avoid CSE (control shift enter) as well. In the second part of the video, I use the Offset formula to create a dynamic list that expands depending on the number of items that should be included in the list. The solution provided is dynamic so if you add new data or change data, everything updates automatically (we use Excel’s Table feature here) Course Length: 14:48 minutes Source: Leila Gharani

Thousands of courses

DisclaimerMany of the curated courses have been manually added into our Learning Management System, then enhanced with structure, descriptive, activities and consolidation,  referencing who the content creators are (where required). If you like the curated content from any creator and like their materials, please feel free to connect with them directly to explore their full libraries of paid programs. 

We will continue to add more curated quality content as well as increasing partnerships with creators to provide you with an all-in-one skills development platform. 

Book a demo now!

Tell us a bit about you. After review, you will receive an invite calendar where you can select your demo time.