Create Dynamic Drop Down List In Excel - Excel Tips and Tricks - video Dailymotion

ExcelTips247

Learn how to create dynamic drop down this in Excel.  Creating dynamic dropdown lists in Excel is a handy skill that streamlines data entry and enhances spreadsheet functionality. To set one up, start by selecting a cell where you want the dropdown to appear and using functions like UNIQUE and SORT to generate a clean list of unique values from your data. Then, go to the Data tab, choose Data Validation, and set the criteria to "List," referencing the unique values you've generated. This process ensures that your dropdown list automatically updates as your data changes, making it dynamic. For example, if you're tracking sales data and want a dropdown list of products sold, as you add new products, the dropdown list expands accordingly, simplifying data entry. You can even create linked dropdown lists where the options in one dropdown depend on the selection made in another, further enhancing your Excel capabilities.  After this video, you should be able to answer the following question.  Create Dynamic Dropdown Lists in Excel How to have a dynamic drop-down list in Excel? How do I create an interactive drop-down list in Excel? What is an example of a dynamic dropdown? Can you auto populate drop-down list on Excel? How to create a linked drop-down list in Excel? How do I create a dynamic table from a drop-down list?  Here are the steps outlined in my video.   Get Sorted Unique Values 1) Select cell F7 2) =SORT(UNIQUE(FILTER(B7:B35,B7:B35"")))  Dynamic Drop Down List 1) Select cell C3 2) Data ~ Data Tools ~ Data Validation 3) Setting tabs 4) List 5) =$B$7# 6) Enter twice   Create Dynamic Dropdown Lists in Excel,How to have a dynamic drop-down list in Excel?,How do I create an interactive drop-down list in Excel?,What is an example of a dynamic dropdown?,Can you auto populate drop-down list on Excel?,How to create a linked drop-down list in Excel?,How do I create a dynamic table from a drop-down list?,  Check out my complete suite of Microsoft Excel Tips and Tricks. https://www.youtube.com/@jjnet247/shorts https://www.tiktok.com/@exceltips247 https://www.instagram.com/exceltips247/ https://www.dailymotion.com/ExcelTips247 https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/ https://x.com/ExcelTips247/media https://www.reddit.com/r/Excel247/ https://www.facebook.com/XyberneticsInc/reels/  #microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks

Transcript

00:00let me ask you this do you know how to create a dynamic drop down list that automatically update

00:04like this aha this is one of the questions i get asked quite a lot too and here's how you

00:10do it

00:10on my data set here i'm going to create a drop down list for my invoice number which is going

00:14to be populated from this list here under the column invoice number here but as you can see

00:19i do have some duplicate values here so basically on cell f7 which is going to be my prep column

00:26here i'm going to run a unique like this and as an argument i'm going to select the entire column

00:32like this and then close parenthesis and hit enter and now if you run a unique if you get a

00:37zero value

00:38here you can basically run a filter function like this filter function the first argument with that

00:44and then the second argument would be i'm just going to copy this cell range b7 to b35 here

00:52not equal to blank like this and close parenthesis one two three times and then after that hit enter

00:59you can see that it does give me a unique set of invoice number now to make myself a bit

01:05easier

01:05i'm just going to encapsulate this unique and filter function with a sort function so that the drop down

01:12list will be in uh in alphabetical order like this here now with that all being said and done i'm

01:18going

01:18to create a drop down list on cell c3 here basically go to data from your ribbon and under data

01:25tools

01:25there's this thing called data validation and when this pop-up comes in here you're basically going

01:30to select uh make sure you're on the setting tab start off with under allow you're going to select list

01:35and on the source you're going to click on this button here and basically click on the very first cell

01:40f7 like this and then you're going to enter a hash character like this this indicates anything below

01:46f7 and then after that you're going to hit enter twice on your keyboard like this and now if you

01:52look at your pull down menu you can see that anything that's listed on f7 and below they are all

01:57listed in

01:57here now as a test if you were to dynamically add some invoice number here maybe one more here 24680

02:05like this you can see that this particular list get updated and on your drop down here you can see

02:10that

02:11two new entries have been added and just as a cleanup work i normally like to go and change this

02:17font color to white so that they are not visible at all

Create Dynamic Drop Down List In Excel - Excel Tips and Tricks

Category

Transcript

Comments

Recommended