Create Multiple Dependent Dropdown Lists in Google Sheets
Vložit
- čas přidán 7. 07. 2024
- #googlesheets #Lists #Listsingooglesheets #googlesheetslearning #googlesheetstutorial #googlesheetsmultiplelists #googlesheetsdropdownlists
This tutorial will show you, How create MULTIPLE dependent data validation lists in Google sheets.
Looking for more? Let me know in the comments below what types of things you would like to learn in Microsoft Excel and Google sheets.
And subscribe for new videos on technology every day...shorturl.at/nsxyJ
Good information
This is the best solution for creating a giant column of dependent dropdown lists. Thank you so much!
Thank you so much for this!!!!!!!Much appreciated!
Great tutorial but I got little confused with my unsorted data. Later found it works proper with the sorted data.
After a long search in multiple channels, I found the required solution. Subscribing your channel for this solution. Thanks again.
Very useful information 👍 thanks for your sharing
Very useful and informative video
Thanks for sharing
Vary good n great information
after so many video tutorials this is the most comprehensive! finally completed my document thanks to this.
Thank you
Same here
Ikr. After countless hours of searching and error. I finally found the best video to explain. Thank you @MD Bytes
Very good information 👍🏻
Awesome video. Finally I got the proper guide to do dependent multiple data validation with little effort 🎉
Very Informative
Really good content.. 👍😃
Useful vedio👍
Thanks for sharing the video. Really helpful
Very useful to all 👍👍👍
i tried different tutorials and this one was the by far the most comprehensive and effective one. Yet mine still was not working, but i added 0 at the end of the match value as a search type and it worked perfectly.
Thanks, it helped me as well!
Very nicely and simply explained.
Informative
One of the super lecturer in the LUC
Great training and by far the best method out there without using app script. Just wondering why data needs to be sorted to make this work (in case you know the underlying reason)
How do we get rid of the "invalid" warning when we go back and select a new value from the first drop-down? This seems to be intentional with Google Sheets, i.e. not an error, but it quite distracting to user of a sheet with multiple drop down lists. Any idea how to get rid of it?
Very information
Nice video
Thanks for a great tutorial.
Thank you 🙏
Nice. Thanks a lot!
thank you for your great information
Very nice
Thanks
Nice
Hi, i created a dropdown list with list items in Google sheet. I want for last item naming "Other" enable any name or text want. You can say a sub category or sub dropdown type thing. Please help.
Thanks in Advance
Good
Thank you for this! This is the easiest option so far hehe
have you done the video using UNIQUE and FLATTEN yet? I can not get the validation to drop down in the Item list. It only holds the first line of items and repeats it on all the other rows. I have 21 categories and I can't make it work. Any help is greatly appreciated. Thanking you in advance.
did you solve this yet?? I am also stranded
What about if we select Same category multiple times the result is not correct? How do you solve it ?
how anyone identify that this is dependent dropdown when you already differentiate the data after applying dropdown.
You have refered from row 4 to 11 data and it took the reference range and from index match, what if i have same category for multiple rows then the reference will not be looping right?
Dear Sandeep, your correct...in such case we shall add UNIQUE with FLATTEN functions to retrieve the cell value of same category in different rows.....with the existing INDEX and MATCH.
@@MDBytes Can you do a video on that for us please
@@sandeepkanukurthy499 sure will do....
@@sandeepkanukurthy499 please can you do it? :D
please show index formula
same thing not working for me in google sheet...wondering what is wrong i am doing
It didn't work for me :( I will try again
This method simply does not work. This formula completely mixes data from different rows. Can you please just write the formula. I might doing smthg wrong...
did you find a solution yet? i also need help
Very nice
Nice