My friend, you made things very simple. I watched few videos and could figure out the second level dropdown. Now I can raise the levels of drop-down to any number. Excellent. I will be subscribing your channel also. Excellent.
Is there a way to remove the '_' in the names of the dropdowns of the first col as excel doesn't allow naming the headers of the tables without the "_". Please help!
Min 8, when you change Make from Hyundai to Honda, the Model and Color stay from your original Hyundai selections - Is there a way to automatically delete the Model and Color selections when you change the Make selection?
Great video btw, can you however solve the problem that you demonstrate perfectly towards the end when you go back and edit the Make but the Model and Colour cells don't automatically go blank. They need to otherwise is shows the wrong info. I'll update if i find a way. Thanks
@@mrinalinimustafee9415 A mix of conditional formatting, data validation with multiple lists and long rules did work eventually. I would send it if i had it still but I didn't actually use it after all as i couldn't rely on anyone to keep it updated with all the new data so it would of become out of date quick. Good luck, it can be done
I followed these steps exactly, but I get an error message when setting the dependent validation. Says the source results in an error. I’m not using any spaces in the naming of the lists either. Can you assist with this?
I had the same struggles. The mistake he makes is at 2:53, this must be a List/range =Make instead of typing the names as he demonstrated. The fix I found was to named the upper ranges first then you can make the cell A14 a data validation list with the range name =Make. Hope this helps.
i followed your way to make dependent lists, however lets say you decide to change the make of the car, it doesnt automatically change the dependent model. How can you make sure that if you change the make of the car, the model also changes automatically?
Hi. I like your explanation. But I'm encountering a problem. My data begins with numbers and it requires me to put an underscore before the name. by the time I'm to select my data for the next column, it does not seem to find matching data. Can you help me with this? I hope I was able to explain the situation. Thanks!
Hi, I've followed all steps and it's a success! You explain so easy and I've been looking through many videos until I found yours! Only trouble I'm having is that the formula doesn't copy itself. I've dragged and done copy paste manually but it doesn't work. Is there a fix? I can't add the same formula for all the rows I have individually haha, it's too many! Thanks
Great, now if we have a scenario of different prices for each make, model and colour and based on the selection from the dropdown, How can we get the different prices?
Great lesson. I made a dependent drop down menu. Now can I streamline this dropdown menu even further to simplify things for my customers. For example my customer doesn't care what make or model he wants all he cares about is that he wants his new car to be PURPLE (and in my example let's imagine there are numerous makes and models to choose from) my customer does not want to sift through all the make/model combinations until he finds a purple option he wants to choose purple first and then be offered the remaining make/model combinations that accommodate his color choice. Can the menus be adjusted to be interdependent...my customers can choose whatever make model color in any order they choose? Some want to start with color others want to start with model... Does my question make sense? Can you help me with this? Thanks!
you might ve to remove the $ sign if you are draggin it down. If not it would not be dynamic and wont get multiple choices when you drag it down to different cells
Do you have video where If I select country 1 (from list of 10 countries) and then move to another drop down list to select country 3 (from list of 9 countries) where country 1 is not an option in this second list.
Final Exams and Video Playlists: www.video-tutor.net/
You're a teacher for life dear!!
Awe
Awesome, Thanks!!! After almost 3 years, still the best explanation about this issue
My friend, you made things very simple. I watched few videos and could figure out the second level dropdown. Now I can raise the levels of drop-down to any number. Excellent. I will be subscribing your channel also. Excellent.
What a guy! thank you, I searched for hours to find this. I'm embarrassed as it's actually so easy to do!
Perfect. That's what I was looking for!!! Thank you mate.
Thank you man. I've been looking for this thing from hours.
Past one week I watched at least ten videos on the subject. This is the easiest one.
worked like a charm!!! Thank you, my client is thrilled he can use this feature for his service reports.
This is 100 times easier solution then any I was trying last 2 hours. Thanks man!
Thanks for your teaching 🥰
Got it after a bit of struggle ! Thank you !
Clear and easy to understand - A good teacher👍👍👍
you are life saviour! !! thank you!
This helped one of my end users. Thanks!!
you made my life easier! thank you!
Excellent teacher ... Thank you 😀
Thanks for the video mate
Very well explained. Thank you so much i desperately needed this formula
Great content!!!!
Nicely explained, easy to understand
Thankyou
Thank you, thank you, thank you!!
AMAZING! You just made me a lot of money! Thank you very much!
Great video, thanks
Very useful in our day to day activity. Very well explained.
Thanks a lot sir, for this Informative video.
This helped me alot
You are the man!! Finally, I can complete my reporting with the correct drop down list options.
Thank you very much 👍🏻👍🏻
Very helpful
Thank you very much, you saved my day with this tip.
Thank you 🎩
Thanks for the video
Very well explained!
i want like this video 1000times
Thank you guy, I got what I looked for, you have a good explanation and easy way to show it, so subscribed in your channel.
You made it so easy,thank you
Thank you so much for making this understandable!
Thank you very much! Well deserved "like"!
Exactly what I was looking for Thank you!
It is really excellent unprecedented vedio
Thank you!!!
Thanks, Simply explained, Great job.
Thank you so much! Been struggling with this for quite some time.
wow - thank you for sharing. You explained and demonstrated that very clearly and simply. well done!
Best. Thanks.
Thanks so much. You have no idea how I've been trying to do this!
I love this 💞
Very useful, Thanks
Thank you!!!!! 🙏
Thanks for explaining it in an easy way. Further if I have to copy this on every row in the sheet then how to do it>
I'm having the same issue. How to get this to work on multiple rows. Did you get a solution?
Thanks for helping me out
Thanks for the video. This was super helpful
nice video carry on
Thanks so much, it really helped. You explained it simple and nicely!
Thanks a lot , after 1 hours i got exact solutions , Really Thanks Sir
Amazing, thanks for sharing this, it's not the easiest thing to do, but you explain it well! thanks :)
Is there a way to remove the '_' in the names of the dropdowns of the first col as excel doesn't allow naming the headers of the tables without the "_". Please help!
I see you left this comment 7 months ago with no reply. Have you figured it out? Because I'm looking for the solution as well.
@@vahidmacvandi1297 @AirSwimmer Use substitute function. Substitute(Select Cell here,"_"," ") this will replace _ with space and will work
@@vahidmacvandi1297 Its Been 4 years. I need an Answer also
Thank you
Thanks for the tutorial! It was far helpful to complete my dashboard
helpful.Thanks
Thank youuu
Well done, well explained and easy to remember as not too complicated.
Very useful
Outstanding Tutorial. Thank you.
WOW, that really helped me out. Thanks alot for such a wonderful teaching
Question: Do you have to keep the cells you used to create the drop downs or can you clean up the spreadsheet and delete the data you no longer need?
Very nicely explained.
Great 👍
Simply way of explaining
Min 8, when you change Make from Hyundai to Honda, the Model and Color stay from your original Hyundai selections - Is there a way to automatically delete the Model and Color selections when you change the Make selection?
Awesome! Thanks
thanks you
THANK YOU! :)
Thanks 😘
This is a great tutorial!
Can you delete those rows from 1 to 11? Or it would affect the dropdown list?
Great video btw, can you however solve the problem that you demonstrate perfectly towards the end when you go back and edit the Make but the Model and Colour cells don't automatically go blank. They need to otherwise is shows the wrong info. I'll update if i find a way. Thanks
Have you found a answer for this? I'm looking for the same info. Thanks in advance
@@mrinalinimustafee9415 A mix of conditional formatting, data validation with multiple lists and long rules did work eventually. I would send it if i had it still but I didn't actually use it after all as i couldn't rely on anyone to keep it updated with all the new data so it would of become out of date quick. Good luck, it can be done
Awesome
Is it possible to ensure that 2nd level selection gets auto reset to null if we select honda after setting hyundai sonata
I followed these steps exactly, but I get an error message when setting the dependent validation. Says the source results in an error. I’m not using any spaces in the naming of the lists either. Can you assist with this?
I followed the tutorial exactly and I get the same problem. doesn't work.
I had the same struggles. The mistake he makes is at 2:53, this must be a List/range =Make instead of typing the names as he demonstrated. The fix I found was to named the upper ranges first then you can make the cell A14 a data validation list with the range name
=Make.
Hope this helps.
@@draw504 thanks bro it works
thanks
can u mix/include drop down lists in words or paragraph?
When a selection is made in each list and I change the selection of the first list, how do I set the subsequent lists to reset to blank automatically?
I have been searching for the answer to this as well. It seems that this is set to possible errors if changes are made to the first cell
I also want the same result
ruclips.net/video/wWasYHG1lmM/видео.html
Great video, really well explained. How would I add information to an existing dependant dropdown?
use name manager to re-select the table
thnks
are these dynamic array functions still available, only on Office 365?
How do i get this to work across multiple sheets in the workbook
i followed your way to make dependent lists, however lets say you decide to change the make of the car, it doesnt automatically change the dependent model. How can you make sure that if you change the make of the car, the model also changes automatically?
Hi. I like your explanation. But I'm encountering a problem. My data begins with numbers and it requires me to put an underscore before the name. by the time I'm to select my data for the next column, it does not seem to find matching data. Can you help me with this? I hope I was able to explain the situation. Thanks!
hi, how do i do if the options from 1st drop down is 2 words?
Hi, I've followed all steps and it's a success! You explain so easy and I've been looking through many videos until I found yours! Only trouble I'm having is that the formula doesn't copy itself. I've dragged and done copy paste manually but it doesn't work. Is there a fix? I can't add the same formula for all the rows I have individually haha, it's too many! Thanks
remove dollar sign ($)
Great, now if we have a scenario of different prices for each make, model and colour and based on the selection from the dropdown, How can we get the different prices?
Great lesson. I made a dependent drop down menu. Now can I streamline this dropdown menu even further to simplify things for my customers. For example my customer doesn't care what make or model he wants all he cares about is that he wants his new car to be PURPLE (and in my example let's imagine there are numerous makes and models to choose from) my customer does not want to sift through all the make/model combinations until he finds a purple option he wants to choose purple first and then be offered the remaining make/model combinations that accommodate his color choice. Can the menus be adjusted to be interdependent...my customers can choose whatever make model color in any order they choose? Some want to start with color others want to start with model...
Does my question make sense? Can you help me with this? Thanks!
How to add the check, x, fx space on the top?
Is there any way how to copy this formula to a multiple amount of cells ? or should I write it manually in each cells ? Thanks
I have this question too - I thought I could drag and drop, but it's not working :(
Same here. I am struggling with this. Any solution?
thank you so much boss i need emergency buttons of how create ADD, Clear without formulas, Search,
NEXT, BACK by using macro
you might ve to remove the $ sign if you are draggin it down. If not it would not be dynamic and wont get multiple choices when you drag it down to different cells
Hi. I tried data validating for 2nd list and it didnt work for me. The =indirect isnt getting recognized. Is there any workaround?
How you drag this dependent list in other cells? Simple drag only takes the last group
Do you have video where If I select country 1 (from list of 10 countries) and then move to another drop down list to select country 3 (from list of 9 countries) where country 1 is not an option in this second list.
How does it work for list that has a spacing? Example full name etc
Add underscore between the names. E.g. Jerica_Soberano