YTLE#75: DV Drop-Down based on DV Drop-Down

Dependent Drop Down lists: See how to use Names, the INDIRECT function and Data Validation Drop Down lists to create Data Validation Lists based on other Data Validation Lists.

Category:

Science & Technology

Tags:

• Excel
• Names
• the
• INDIRECT
• function
• and
• Data
• Validation
• Drop
• Down
• lists
• Dependent
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[paulobyrne0402]

Hey ExcellsFun, thanks a million for all the videos, they're brilliant. Quick question, I've created a table with a number of rows and columns of data, and I'm trying to create a dv list from it. The first colum has a list of manufacturers, but there are duplicates in it, and when I create the dv list from that column in the table, its giving me all the duplicates aswell. Is there any way to get rid of the duplicates when I create the dv list?

[ExcelIsFun]

If you wanted it to be dynamic you would have to build a complex array formula. See this video:

Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula)

Otherwise, you could use Extract Unique list:

Excel Magic Trick 82: Advanced Filter Extract Unique Records

Then make your DV.

[elkim27]

Mr. ExcelIsFun, Thanks for all your videos. Learning a lot here. It seems like the data validation of data validation doesn't work if the name is dynamic. So if LP was a dynamic named range using the offset function, then the indirect of that name won't pull up anything. Would you happen to know a way around that? Thank you!

[ExcelIsFun]

try these videos:

You Tubers Love Excel #1: Dynamic Data Validation & OFFSET

Excel Magic Trick # 259: Dynamic DV List Based On DV List

[ExcelIsFun]

No - I don't even think Microsoft knows that excelisfun exists.

I am glad that you enjoy the videos.

[poor750]

@ExcelIsFun

Does Microsoft pays you? I love all your videos.

[ExcelIsFun]

I do not know how to use Open Office .

[graceoverall]

I'm trying to do something similar, but I'm working in Open Office so obviously the shortcuts don't work. What are the actual command names or dialog boxes? Ok, so I have my Data Validation drop downs setup, They are parallel data ranges similar to what you have here. But what I want is for it to look at the particular value I've chosen from either drop down (so it works in both directions) and automatically selects the CORRESPONDING VALUE in the other drop down.

[ExcelIsFun]

This video shows how to do that.

[lweesian]

how could i do dv drop down base on another and another.