Perfect, no music, clear speaking and intelligent! Click here to send him a new BMW
@lovermaxwell1343
4 жыл бұрын
the best video to show the easiest way to set Downlist as so far, no need any edit any sourcecode.
@justfly2525
6 жыл бұрын
INDIRECT: Awesome, I've needed that function so many times!
@thesheetsguy4478
5 жыл бұрын
Great tip about leaving room in your range to add items in the future since blanks won't be included in the drop down.
@telorceplok8812
3 жыл бұрын
this is the most useful youtube channel ever
@kinematicspt
3 жыл бұрын
Wish I found this back in 2017! Thanks for putting it together!
@menzoberranzam
3 жыл бұрын
It can get quite complex, but it's very useful, and your tutorial was great. Thank you.
@gsuiteetmat6300
4 жыл бұрын
I have often use indirect, this is a really powerful function. Nice content !
@cortega26
3 жыл бұрын
Works perfect for row 2, but what if I need data validation for multiple rows?
@Lola.Owlace
3 жыл бұрын
kzitem.info/news/bejne/1GN_no5qp4Z1lKA
@extremegaming8718
Жыл бұрын
Is this answered
@realOjive
3 жыл бұрын
@7:40 MY MAN! Thinking ahead and creating solutions for upscaleability (if there is such a word). Great tutorial and I am VERY grateful for it. Thank you
@HassanAlmaateeq
3 жыл бұрын
Great presentation skills and teaching habits
@transparent91
3 жыл бұрын
Amazing tutorial thank you. Just took a workload off one's shoulder with these nifty tips. I especially liked the "define named range". While struggling to get a function to work, it's really tedious having to mark up the ranges again and again.
@karlsickafus2027
3 жыл бұрын
Excellent presentation. Did a lot of pausing and rewinding. But, finally mastered the concept. Works perfect!
@thuytram9414
3 жыл бұрын
thank you very much, very easy to understand, you are a very good teacher. many thanks
@Red-fg9qr
3 жыл бұрын
Ages later, this is still helpful! ty needed something like this.
@SRDFTM
3 жыл бұрын
Try this with FILTER function, when you understand how to do it you'll absolutely love it)) Thanks for the video
@apk29
4 жыл бұрын
Love your videos, they have helped me figured out so much! Thank you!
@SteveInGeorgia
5 жыл бұрын
Works great for one row. But what if you have a list of people, say karate students, each with a pull-down for rank (beg, int, adv, black) and a contingent weight division indirectly linked to rank (light, light-middle, middle, middle-heavy, heavy). Do I have to construct this for every student? I tried using the indirect function in the data validation window and I get an error.
@omarkhaled390
5 жыл бұрын
In excel we can do it easily, if I have a column full of drop down how to do it ? In excel we enter it (Indirect formula) directly in data validation bar, how to do the same in google docs?
@igorandrade8531
8 күн бұрын
Do you how to? I'm facing this issue rn
@xpo274
3 жыл бұрын
Can the data validation extend to more rows? Row 3, column B is pulling from what I input in row 2 column A.
@aimeo.saladaga2505
3 жыл бұрын
same question here, hope to get an answer.
@Dangerica4you
3 жыл бұрын
@@aimeo.saladaga2505 check link below, maybe it will help
@mindhive625
4 жыл бұрын
Unbelievably helpful
@greggroos4105
Ай бұрын
Excellent, echoing Mr. Parsons, you have that knack for speaking off the cuff with very few errors. Could you bottle that ? You could retire! I had no inkling that I could make a validation range from a ROW, I've always assumed COL only. Video would have been worth it just for that
@jacobmason7947
3 жыл бұрын
Just what i was looking for straight to the point, would give two thumbs up if i could thanks
@lubnashaikh8232
4 жыл бұрын
This is great! Very detailed explanation of the concept. Thank you :)
@kayitonder1405
2 жыл бұрын
Impressive. The tutorial is very easy to understand. Thank you.
@ariefmdnor5201
Жыл бұрын
Thanks sir...your video gave me inspiration. Finally this is the code I wanted: =FLATTEN (INDIRECT (F12),"") A cell referenced to a dropdown which is inside the dropdown is my ranged name. But I want convert it from horizontal to vertical. So I use FLATTEN funtion.
@jimeva7363
3 жыл бұрын
Very cool. But, I would like to be able to have the dynamic lookup for an entire column. This works great if you are only doing it for 1 cell. I want to have two columns where the values for cells in the first column determine the choices for the values in the second column.
@praveenkumarlk8527
2 жыл бұрын
hi did you got answer for this..? same doubt for me also
@ahamedjameel8480
5 жыл бұрын
This is one of the coolest things I know in Excel.
@ushakarkeerthi5077
5 жыл бұрын
Thank you very much. I got what I expected. Keep posting
@gaberiley1531
6 жыл бұрын
Bless your soul. This is pure genius.
@FarahNazifa
4 жыл бұрын
Thank you so much. This video helped me change the names everywhere but it worked. Thanks.
@malikastar9265
Жыл бұрын
Amazing tutorial, very detailed as usual, thank you !
@aldrianraffiwicaksono2269
3 жыл бұрын
This is actually clever! Love it
@Thenarayanaclips
2 жыл бұрын
That's really an awesome tutorial, brother. Thanks a lot for sharing this with us.
@rajakaz4075
3 жыл бұрын
Great! Thank you very much!!
@lidonevita
4 жыл бұрын
super good explained! thnks :)
@yourvirtualhelpbiz
3 жыл бұрын
Now I can sleep! 😂 Very well taught. Thank you!
@bobykumar3960
4 жыл бұрын
thank you so much.
@janeo14
2 жыл бұрын
WONDERFUL CHANNEL! i wish i saw this earlier. do you have a video explain in short the differenct formulas? (example IF is.... SUMIF is.... IMPORT ..LINKING... QUERY ) trying to go thru all your videos to see what is relevant for my work needs. thank you again for teaching !
@ruzaqir354
4 жыл бұрын
Many Thx for the knowledge man u deserve more views and sub.. sadly alot of ppl love to watch compilation tiktok videos. Keep doing this man
@pelageyainna3108
Жыл бұрын
Thank you sooo much, you safe my " ass" .....I just fixed my old Table which I completely forget how to arrange.
@crokis372
2 жыл бұрын
Amazing!! Just what i was looking for. Thanks for sharing!
@ExcelGoogleSheets
2 жыл бұрын
Great to hear!
@techeng13
5 жыл бұрын
You are a good teacher, thanks
@laurawences4205
3 жыл бұрын
When I auto fill the rest downward. It would give me like vegetable = mango when it should be vegetable = Broccoli. I think the indirect isn’t working when I autofill
@alistairgene
Жыл бұрын
Thank you very much for this video! One question though - what if you need to name the range with a name that has spaces in it, like say the name of a US State like "New York?" 'Cause mine says invalid name.
@ecojarzinc
6 ай бұрын
I'm having the same issue. I can't put spaces or punctuation in the Named range. I haven't figured out how to get around this. The example in the video he is only using single words, but I have much more complex names in my spreadsheet!
@interrecipes6822
3 жыл бұрын
Wonderful. Is it possible to extend to more than two independent drop down lists?
@deepakagarwal6014
4 жыл бұрын
I need help about these validation, what I do if I need that dependent validation for next few column also?
@nadirgirl
4 жыл бұрын
This is exactly what I am looking for too. Were you ever able to solve this?
@berendotto
4 жыл бұрын
I am also in need of this feature. In excel no problem... Any luck?
@deepakagarwal6014
4 жыл бұрын
No, I still did not found solution for this except script based macro 😞
@iswandi_j
3 жыл бұрын
I think you need to learn about arrayformula method and filter function. Filter(array,criteria) If you need 3 level. That means, the first input you chose will be the criteria for the second input. The second input will be criteria for the third input. And so on.
@zayedhasanchowdhury
Жыл бұрын
I have a question, in this system, I get it in one cell only. whenever I drag the dropdown list, to the next cell it didn't work!! Like If I try this in A2 and B2, the double dropdown is working, but in A3 when I select an option, B3 is not showing the result I need. It shows B2's results.
@Den-Geist-Befreien
5 жыл бұрын
Thank you! I've seen it done is with array formula function, but this seems to be more readable. Not as intuitive as Excel, but awesome either way!
@sopanshirdhonkar969
Жыл бұрын
what you in Main you have multiple entries of Make. e.g. A2- Toyota, A3-Mercedece , then in lists sheet do i need to duplicate that dynamic generated values. i wanted to create an expense tracker with expense category and subcategory. although on google sheet not able to use INDIRECT function in the datavalidation LIST, it works on MS excel. e.g. in data validation list range =INDIRECT(D2)
@manojthapavmsrspecialistup2732
4 жыл бұрын
Thank you! This was so helpful!
@Jpsans98
3 жыл бұрын
OMG this is what i need!! Thank you sm !!
@justwalkingwithme
3 жыл бұрын
thank you very much, this is answering my question
@brianmwevi4344
5 жыл бұрын
Thank you very much for the tutorial. Very helpful!
@jufrensiusbarasa6870
4 жыл бұрын
Awesome. This video helps me. Thank you!
@DimitarSavov87
3 жыл бұрын
Very nice tutorials! I've learned so much from you! But I have a question if you don't mind: If you continue down the A column with brands, how can you make the dropdown in B column continue down as well and be dynamic as it is in the video? I mean, lets say A3 is BMW, A4 is Audi, etc. how can the B3, B4 update as well and all this to continue down the columns? Thanks!
@Sankofa906
2 жыл бұрын
?
@smaccsi
2 жыл бұрын
@@Sankofa906 what do you not get ? he just wants to have more dynamic dropdowns beneath the first one
@anpopochava
4 жыл бұрын
thanks a lot!!!!!!, know... how do I do the same fo multiple rows in the " main " tab?
@learnspreadsheets
6 жыл бұрын
Can this be done using a FILTER function? So that its more dynamic & doesnt need named ranges?
@memh314
3 жыл бұрын
Great video...very easy to follow!
@mamdouhthabet6695
6 жыл бұрын
Is it possible to continue this validation down the column? So that if A3 is Audi, B3 will also only show the option available for Audi?
@ExcelGoogleSheets
6 жыл бұрын
kzitem.info/news/bejne/kol_tGmEsoNqmaw
@aerieleah533
3 жыл бұрын
You missed a trick with naming the ranges. You could have also listed the range to be C3:C. This would have made the range go on and on to the very bottom. Same works from C1:1. Otherwise this really worked to demonstrate this.
@militer3675
6 жыл бұрын
Now make second similar row
@toucanyuval
5 жыл бұрын
How do i apply it to the rest of the cells on the main column?
@fabiano-co
3 жыл бұрын
Did you figure out this?
@General_DDay
2 жыл бұрын
Great video, but is there a way for a user to add to a list from the dropdown list. For example if the user wanted to add a new make of car, say Ford, the user can just type it in from the dropdown list and it will be added to the list?
@sidselpedersen6635
4 жыл бұрын
That is crazy useful - thank you!
@DanEMO592
4 жыл бұрын
Amazing! Thank you so much!
@petrakmetova9595
3 жыл бұрын
and how to copy those drop-down cell also for the whole row?
@jenniraeventling3470
4 жыл бұрын
This was so helpful thank you! Could you direct me to a way to duplicate the function of the cells drop-down lists to multiple cells? or do they need to be done individual rows as show above?
@dzilen
4 жыл бұрын
I guess the author does not know how!!! without this function his advice is not very helpful
@GOLDENPUNJABMSPEW
2 жыл бұрын
And what can we do for multiple rows with same drop down button like for countery and then district
@rajmellvin8469
2 жыл бұрын
You have mentioned for only 1 cell as an example. what to do if we have 2nd row Main sheet A3 and A4 etc, how will it work?
@mouhammadali9605
2 жыл бұрын
Help! I am trying to use conditional formatting to highlight a cell that contains certain value in two different sheets . I am struggling with the formula, could someone please advise?
@asefTutorials
4 жыл бұрын
Great job I like your way to do that AWESOME
@abinayas6151
4 жыл бұрын
just awesome
@tracyselena
2 жыл бұрын
How do you deal with this if the car brand was 2 words? Because the named ranges cannot have spaces and I want the dropdowns to have proper spacing. For example Alfa Romeo...how would that work?
@mahesasanggadipa
Жыл бұрын
how about 3 level drop down? like Toyota -> Land cruiser -> AT or MT or like other
@mohitksachan
Жыл бұрын
It's applicable on specific one cell and one row. Is there any alternative for multiple row? Please help me out if I selected " Main!A3, A4, A5.............An"
@pedroramirez9254
3 жыл бұрын
Thanks. Very helpful. How to do the same dropdown list several times in the same google sheet? Thanks.
@casimirocoach
2 жыл бұрын
How can I do this if it is not vertical? If the first data validation is vertical, not horizontal. All data on my sheet is horizontal. Thanks!
@thaocao3563
3 жыл бұрын
This is so amazing! Thank you for sharing!!!!
@ExcelGoogleSheets
3 жыл бұрын
Glad you enjoyed it!
@thaocao3563
3 жыл бұрын
@@ExcelGoogleSheets If I want to create a series of such dependent dropdown lists like this, how can I do it? I can not drag it like usual right? What should I do? Can you show me how?
@uqbaabuhusaina5939
3 жыл бұрын
Hey every thing is good but should we do this to each cell for data validation, if we need this kind of dropdown list in whole sheet?
@getnetdemil
2 жыл бұрын
hello, I have created a google sheet of 6 users shared in editor permission to the sheet. each users input their own data and they only can modify it later. But I want to restrict other users from modifying other's data in google Sheets? I don't want others can change someone data so if anyone with the app script code to restrict modifying others data, please help me??
@shane673
3 жыл бұрын
After you select the model, would you be able to populate some cells to the right to display packages available, without them being in a drop-down? So after you choose Toyota and Corolla, could you (to the right) display: [L] [LE] [SE] etc? Brackets denote a separate cell.
@giottogiannandrea303
3 жыл бұрын
There is any way to copy the sheet with the indirect drop downs cells into a new spreadsheet?
@terryeckmeier7027
4 жыл бұрын
I am trying to make a comment building that selects E,G,S,N and then predetermined comment. I have 25 studeents and was wondering how to I make this function go down for 25 students. I tried dragging but it only gives me one reference option from the first cell. Any suggestions.
@shootakilla27
7 ай бұрын
How do you add that to multiple cells? If I want to add multiple makes per say
@kytran6657
Жыл бұрын
Is there a way to do the dropdown on every row? which will depend on the value beside it. For example column A will hold the first dropdown and B dropdown will depend on column A.
@makhan5062
4 жыл бұрын
I want to make drop down list which is dependent on the different cell not in different drop down list. Suppose a cell carry different number. I want to make drop down list in different cell which is dependent on the number cell. Example in a cell carry upto 5 there are different drop down list and if it more than 5 then there will be different drop down list. Please help me out. I'm unable to find the solution from last 2 week.
@md.sibgatulla842
3 жыл бұрын
I love you this is the best one
@GV-gn3mj
Жыл бұрын
Very useful, thank you!
@lukebiernbaum
6 жыл бұрын
Thank you so much this video helped a ton!!
@acrykhus
6 жыл бұрын
is it possible to eliminate an option from a dropdown after it is selected, I have several drop down lists, and I want to make sure I can't select the same item multiple times from a single list.
@MrNickPearson
3 жыл бұрын
Great video, can someone please let me know if this method will work on Google AppSheets if I somehow hide the sheet from being included with the regeneration of the appsheet..?? Thanks in advance..
@francelinoximenes3281
2 жыл бұрын
Can you make a list of Universities automatic with its department when clicking on 1 university
@sulthansherieff1851
2 жыл бұрын
Could you please make a video on how to perform the same operation in google form?
@nikolasdimopoulos5711
Жыл бұрын
Hi there, very helpful video. Is there anyway you can do the indirect function for multiple cells simultaneously or you can do it only one by one? thanks anyway
@abdulrahmanbinmuhydinkpm-g2417
2 жыл бұрын
TQ for the tutorial. After spent a lot of time mastering this, so sad when it is only function in first cell, cannot drag down the formula. Anybody face the same problem? somebody can suggest a solution? TQ in advance.
@hernanjorgewagner
5 жыл бұрын
Thank you so much!! Great tutorial!!!
@karenyenvn
5 жыл бұрын
Good training! Thank you!
@nicholasazoya1556
5 жыл бұрын
Thank you for the tutorial.
@thejrkanglearchived
3 жыл бұрын
Very helpful. Anyone know how I can do this for multiple rows of dropdown and still work?
Пікірлер: 324