Unique Drop Down Lists that Automatically Update with New Values

How to make a data validation drop down list that will always update with a unique list of values from a table or column of data in Excel.

This allows you to generate a list from any table or data set without having to first remove duplicates. You can even sort the values in the list without any extra steps.

I hope you enjoy this Excel tutorial!

Resources:

#msexcel #tutorial #exceltips #freetutorial #exceltips #excel

[howtomasterexcel]

Thank you for sharing this video. It's so well explained!

[rogjfie]

Thank you very much Sir, this is what I look for it.

[TeachTech]

Nice video. Can you create a video focusing on creating a dropdown list that imports a formula, not a value, from another sheet. Thanks.

[ASI]

Close but no cigar - what I am looking for is an Excel Drop Down List - typing the first letter selects matching names. My understanding is that Excel 365 online has this functionality, and many MS Experts, such as you have seen a preview desktop version with this functionality. I was hoping this was a workaround, but I still must select the dropdown and select it with the mouse. What I need is to type the first couple of letters, use arrows to select, and hit enter or tab to select and go to the next field. I watched your videos regularly, and it has improved my Excel skills significantly. Thanks for the training. Sorry if my explanation is long and unclear.

[salamander]

This is handy and easy. Recently I wanted to integrate this function. But I did that whit the name manager function, to make a "reference". (There are more ways to Rome, do we say, and this is a example of that!)

[johnbutler]

You don’t need a table if you use the offset function, with rows as the counta of the identifier column - header

[interken]

I have office 365 that I use the desktop version as well as the browser. When I select the top cell of my list and add a # after it, it gives me an error (in both versions). I really could use a drop down list that self adjusts when the source list does. Right now, I just include a bunch of blanks at the bottom of the list which gets included in the drop down list.

[MichaelMcGurk-ibqq]

Does anyone know how to do this in Microsoft access

[cis]

I don't get it. What is the point of your drop down list? Normally, it would be validating column B. Can't use it their because you allow new values. Please enlighten me.