Excel - 1 to Many: Dependent Dropdown List

No video

Excel - 1 to Many: Dependent Dropdown List

Рет қаралды 1,750

2 ай бұрын

Learn how to create a typical dependent dropdown list, but also how to create a "1 to Many" dependent dropdown list where 1 dropdown can alter the behavior of multiple secondary dropdown lists.
File Download Link:
www.bcti.com//...

Пікірлер: 32

@hankgrimes1806 2 ай бұрын

Wow! This is really useful stuff. Just grabbed the workbook and can't wait to practice these techniques. Thanks for sharing/1

@bcti-bcti 2 ай бұрын

Thank YOU for watching and supporting the channel!!!

@robbe58 2 ай бұрын

A very useful and efficient way to populate different connected dropdown lists. Explained and documented in a very professional and helpful manner.

@bcti-bcti 2 ай бұрын

Thank you 👍👍👍

@thelastfry23 2 ай бұрын

Great video! My favorite way of doing dependent dropdowns is referencing a spilled range in the data validation that is created using a filter function on another sheet that is filtered using the initial dropdown. So for the example you used for the multiple ranges you can use the initial INTL/Domestic input to filter three different ranges to feed the three dependent dropdowns. This can also then be used to have multiple dependent dropdowns using multiple filter criteria.

@bcti-bcti 2 ай бұрын

Can you provide an example of how the FILTER function could focus the other dropdowns on their respective entries? My brain isn't connecting on this one. Thanks.

@thelastfry23 Ай бұрын

@@bcti-bcti Sent an example workbook to your email!

@bcti-bcti Ай бұрын

@@thelastfry23 I did not receive any email. The address is "training@bcti.com"

@thelastfry23 Ай бұрын

@@bcti-bcti Sorry about that, it was sitting in my drafts! Should come through shortly!

@arbazahmad7177 Ай бұрын

Excellent... thanks for sharing 🎉.

@bcti-bcti Ай бұрын

Thank YOU for watching!!!

@Luciano_mp Ай бұрын

Greats examples, Thanks!

@bcti-bcti Ай бұрын

Thank YOU for watching and commenting.

@chrism9037 2 ай бұрын

Super video, thank you!

@bcti-bcti 2 ай бұрын

You are quite welcome. Thanks for watching.

@anindyamukherjee7690 2 ай бұрын

Very much useful. Great ❤

@bcti-bcti 2 ай бұрын

Thanks for watching!!!

@petrabauer678 Ай бұрын

This is brilliant 🎉

@bcti-bcti Ай бұрын

Thanks so much for suck kind words. We appreciate you taking the time to watch.

@AMDSTT Ай бұрын

Good job 👍👏

@bcti-bcti Ай бұрын

@@AMDSTT thank you!

@tomstrack42 2 ай бұрын

Extremely useful, thanks!!!

@bcti-bcti 2 ай бұрын

You are very welcome. Thanks for taking the time to watch.

@teekayjunior2517 Ай бұрын

Can this work where the various lists are formal Excel tables (not just presented in tabular format)?

@bcti-bcti Ай бұрын

Off the top of my head (without testing) I would think that it would be difficult to perform this using proper Excel Data Tables, as those tables cannot have duplicate headings. The three "plain" tables in this exercise all have identical headings.

@Adam_K_W 2 ай бұрын

It would be great if Microsoft would allow for the Filter function to be used directly in Data Validation with spilled arrays. All of this would be so much easier.

@bcti-bcti 2 ай бұрын

Even though you can't use the FILTER function directly in the Data Validation tool, you could have Data Validation point to a spill range generated by the FILTER function's output.

@Adam_K_W Ай бұрын

@@bcti-bcti true and I do use that but then you need the helper areas set up

@bcti-bcti Ай бұрын

@@Adam_K_W Life is one big, giant compromise.

@Adam_K_W Ай бұрын

@@bcti-bcti indeed! It's an exercise in managing opposing forces on a good day.

@maciejkopczynski55 Ай бұрын

@@bcti-bcti Yeah! unfortunately, the Data Validation Dialog Box requires a range reference or a formula that returns a cell reference, so sometimes we can get it to work using INDEX or OFFSET functions as they do return cell references not just values. But I too always suffer from having to point to a location in my sheet instead of just generating the list on the fly.