Excel Dependent Drop Downs with FILTER
Вставка
- Опубліковано 10 лют 2025
- Download File: www.excel-univ...
Learn Excel Fast:
www.excel-univ...
www.excel-univ...
This video shows how to create multiple dependent drop downs using the FILTER function. These are also known as cascading or conditional drop downs, where the choices in a drop down depend on the selection made in a previous drop down. The technique presented enables you to create as many drop downs as you need, and there is no VBA coding needed.
Note: depending on your version of Excel, you may not have access to the FILTER function. If not, check out this post which uses legacy functions or this post which uses slicers.
There are hundred of videos on youtube that explains the process fo creating dependent dropodowns but this video is a gem. You have addressed a problem of creating level-1, level-2 & level-3 dropdowns. In your video you have also explaned how a level-3 dropdown can depend on level-1 check. No other video does that. Thanks alot !!
Thank you sincerely for your kind note!
This is EXACTLY what I was looking for to set up a way to sort through 73 different payment options for tuition at a school I operate. Thank you so much!!!!
I'm so glad it was helpful!!
Unbelievable, well done sir!
So many videos try and explain dependent drop down lists yours is the most powerful and useable.
Excellent. I did not know the thing about AND = * / OR = +. Makes so much sense. Thank you.
Glad it was helpful!
Super helpful information, your direct and clear way of explanation is so professional. I too saw so many other videos, but yours is the most helpful. First time I know about the hash symbol and the effect of * / +
Great way of doing dependent drop downs Jeff 👍So much easier with these array functions hey !
Fast, helpful and easy to follow, thank you !
Lifesaver! I was trying to do Indirect formulas, this is so much simpler. Thanks so much
Glad it helped :)
Thanks a lot for your videos. and I hope everyone watch your videos to press like button to thanks you for what you doing.
Thank you!
You are the champion, my friend 👌
Thank you ... glad the video was helpful!
Outstanding! This is exactly what I am looking for. Thank you!
Excellent ... glad it was helpful!
Question.. How do I expand the selection across multiple rows? We're only setting the reference to 1 specific cell. Thank You !
THis is really good content. I have managed to make that in an horizontal fashion. But I want it to work for many rows, simply copying the rows is not working, how do i make it work for multiple rows?
Smart solution on using the hash key in the drop down and having the data validation prep table
I'm trying to get multiple drop downs to match. This video is close but it only does it for the top row. I need it to work all the way down a worksheet. Any tips?
I also looking for multiple row as well, have you got any lead on this
Big applause!!! Fantastic!
Thank you … glad it helped!
Outstanding, Just what I looking for, congratulation and Thank you so much
Thanks ... glad it helped!
Wow! wonderful video. I would like to know whether we can do this without drop down prep.
Fantastic!!! Is there a way to place directly the formula in the Drop Down Prep in the Data Validation Source?
many thanks for that valuable informations
Awesome video
Glad you enjoyed it
Awesome 🎉😊
Super sir❤
If I need to have the same but for multiple entries, Is it doable?
I was SO excited when I found this video because it was EXACTLY what I was trying to do, but then I was crushed to find out that my Mac version 2019 does not have the UNIQUE Function :o(((( How can I accomplish this without the Unique Function?
Does anyone knows how to search entire workbook and return all records which match a certain value from a drop down list with or without a Macro?
e.g. if we have a list of many large organization in a worksheet and have a list of all of their employee, first name, last name, phone, email, title,..... ( many per organization) in another worksheet.
How one can see the records of all employees in an organization by selecting the organization's name from a list or drop down box, etc. I would appreciate if your insights.
When entering the table column into the unique function, how do you select the table column? What keyboard shortcut u use?
Enter the table name and then type the open square bracket [ to reveal the list of column names.
How would I manage the options when there are 7 options as in my scenario there are literally 1000's of combinations ? and I also need to price an item where some options are prohibited with prior selection, so in other words in your model, if they choose "hoodie" it could have a zip, but if they chose t-shirt, ZIP *which may have been selected as a preferred choice) would NOT show t-shirt available, ... and I have several dependencies like this... If I try and do a table containing every option there are about 10000 table entries, but the actual raw data to "build" the item is a few simple selections...
you cannot instantiate a new instance of drop downs, it only works once, the subsequent iterations are static and return the same data as the first. how can we have multiple drop downs that are unique?
When I type in the UNIQUE code, it brings up the #NAME? error. Help page says to try inserting a function. Insert function doesn't even have UNIQUE as an option.
Upgrade your office
UNIQUE Function is not support 2013 plz support
IT would help a lot and save a lot of time for a person if you FIRST MENTION that the UNIQUE feature/function, as well as Filter function, are ONLY available in EXCEL 2020 or 365 - Thank you for wasting my time - I hope others feel this helpful.
Thanks for the tip!
no good. I have clients that are still on excel 2016.