This is the best solution for creating a giant column of dependent dropdown lists. Thank you so much!
@cyberghost9330
3 жыл бұрын
after so many video tutorials this is the most comprehensive! finally completed my document thanks to this.
@MDBytes
3 жыл бұрын
Thank you
@shaykh_dubai
2 жыл бұрын
Same here
@samarthnair9359
2 жыл бұрын
Ikr. After countless hours of searching and error. I finally found the best video to explain. Thank you @MD Bytes
@candykhoza6984
4 ай бұрын
Thank you so much for this!!!!!!!Much appreciated!
@samethasrimutharamman
2 жыл бұрын
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.
@nishanthkumar7627
Жыл бұрын
Awesome video. Finally I got the proper guide to do dependent multiple data validation with little effort 🎉
@meenakshisoni4936
3 жыл бұрын
Very useful and informative video Thanks for sharing
@CubeShape-nn5ze
3 жыл бұрын
Very useful information 👍 thanks for your sharing
@withbbna
Жыл бұрын
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.
@aslam1904
Жыл бұрын
Thanks, it helped me as well!
@11-zm-prestige-sylhet-imra12
3 ай бұрын
Good information
@suryakantamishra4748
3 жыл бұрын
Thanks for sharing the video. Really helpful
@artist.rathnayake2684
2 жыл бұрын
One of the super lecturer in the LUC
@saranyaprem1
3 жыл бұрын
Very Informative
@rohamitik5255
2 жыл бұрын
thank you for your great information
@sanjaykumarsingh8493
2 жыл бұрын
Very nicely and simply explained.
@rohits1798
3 жыл бұрын
Very good information 👍🏻
@sriganthvenkatesan4934
3 жыл бұрын
Very information
@HennasKitchen
3 жыл бұрын
Informative
@discovervyanjan8208
3 жыл бұрын
Vary good n great information
@11-zm-prestige-sylhet-imra12
3 ай бұрын
Thanks
@AnhTran-wp2jh
2 жыл бұрын
Nice. Thanks a lot!
@pbiswas600
3 жыл бұрын
Useful vedio👍
@akshitmehta8357
3 жыл бұрын
Very nice
@classy110
2 жыл бұрын
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)
@kitchencooka5865
3 жыл бұрын
Really good content.. 👍😃
@kiruthikak4235
3 жыл бұрын
Very useful to all 👍👍👍
@revaj6750
3 жыл бұрын
Nice
@pamcollins9080
Жыл бұрын
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.
@TheLoloCynthiaShow
7 ай бұрын
did you solve this yet?? I am also stranded
@marius9897
3 жыл бұрын
Thanks for a great tutorial.
@MDBytes
3 жыл бұрын
Thank you 🙏
@mirzafarhan7883
Жыл бұрын
What about if we select Same category multiple times the result is not correct? How do you solve it ?
@sangeeta4973
3 жыл бұрын
Nice video
@sandeepkanukurthy499
3 жыл бұрын
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?
@MDBytes
3 жыл бұрын
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.
@sandeepkanukurthy499
3 жыл бұрын
@@MDBytes Can you do a video on that for us please
@MDBytes
3 жыл бұрын
@@sandeepkanukurthy499 sure will do....
@GoProGuyHD
3 жыл бұрын
@@sandeepkanukurthy499 please can you do it? :D
@preethasmakesbakes9706
3 жыл бұрын
Good
@babblerfishtranslation8024
2 жыл бұрын
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...
@TheLoloCynthiaShow
7 ай бұрын
did you find a solution yet? i also need help
@charlesrondos1888
2 жыл бұрын
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?
@fasaquotes
3 жыл бұрын
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
@DominadorsPOV
2 жыл бұрын
Thank you for this! This is the easiest option so far hehe
@kyawswar2259
2 жыл бұрын
please show index formula
@rahulpawartube
2 жыл бұрын
same thing not working for me in google sheet...wondering what is wrong i am doing
@saurabh6622
2 жыл бұрын
how anyone identify that this is dependent dropdown when you already differentiate the data after applying dropdown.
Пікірлер: 53