Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)

  Рет қаралды 1,819,880

Leila Gharani

Leila Gharani

Күн бұрын

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Learn how you can create MULTIPLE dependent data validation lists in Excel on the SAME sheet using a single formula. This formula also excludes blank cells on the bottom of the data validation list.
⬇️ DOWNLOAD the workbook here: pages.xelplus.com/multiple-de...
👩‍🏫 Step-by-Step Tutorial:
Start with Basic Drop-Downs: Learn how to create a basic drop-down list for divisions.
Tackle the Challenge: Dive into creating a dependent drop-down list for apps based on the division selected, using the OFFSET formula.
Formula Magic: Discover how to dynamically change the drop-down contents using OFFSET and MATCH functions.
Avoid Empty Choices: Learn to dynamically adjust the number of choices in your drop-down to avoid empty selections.
Apply to Multiple Rows: Easily copy and paste the validation to multiple rows for a consistent, user-friendly experience.
🔧 Key Techniques Covered:
OFFSET Function: Understand the OFFSET function for dynamic range selection.
MATCH Function: Use MATCH to locate and select the correct column based on division.
Dynamic Counting: Implement COUNTA with OFFSET for dynamic list sizing.
In our example the selection of a division will drive the available choices for an app in an Excel data validation list. We'll use the Excel OFFSET function and the MATCH function for the dependent drop down selection. This way you can have as many categories as you like.
The challenge we have is that the number of choices inside the dependent drop down may vary depending on the division. I'll show you 2 solutions for this:
Fixed number of Choices in the dependent drop-down
If you do not mind empty spaces (blank cells) at the bottom of the drop down you can fix the height argument in the OFFSET function to a specific (maximum) number of choices.
Dynamic number of Choices in Drop-Down
If we want to restrict the number of visible cell values inside the dependent drop-down we can expand the formula to get rid of the blank cells on the bottom. This way we can eliminate empty spaces in the drop down selection. We will use another OFFSET formula inside a COUNTA formula to dynamically count the number of available choices.
00:00 Dependent Drop-Down Lists in Excel on EVERY Row
01:20 Creating the First Drop Down
01:58 Creating the Dependent Drop Down List
05:55 Fixed Number of Choices in the Dependent Drop-Down
07:15 Dynamic number of Choices in Drop-Down
10:21 Copy Down Data Validation
LINK to related OFFSET video: • Excel OFFSET Function ...
Complete Excel Data Validation Playlist: • Drop Down Lists in Exc...
➡️ Join this channel to get access to perks: / @leilagharani
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel

Пікірлер: 1 300
@LeilaGharani
@LeilaGharani 9 ай бұрын
Grab the file I used in the video from here: pages.xelplus.com/multiple-dependent-dropdowns
@djunabug
@djunabug 4 жыл бұрын
Perfect!! Thank you so much Leila! One thing I just learned the hard way is that COUNTA counts not only cells filled with contents but also with formulas, as well as null values ( "" ), after copy-pasting values to escape the formulas. The latter had me stumped awhile, with lots of extra blanks. A good "Clear All" beneath each of my subcategory lists got me sorted, and now I have beautiful drop-downs. Thanks again!!
@LeilaGharani
@LeilaGharani 4 жыл бұрын
That's great. Thanks for sharing!
@jimlimberdavis2400
@jimlimberdavis2400 4 жыл бұрын
I'm always learning something new with these videos! Absolutely love LG!!! I typically don't use the formulas presented, but I do incorporate small aspects of the formulas used; in this case, Counta. Paying attention to the 'moving' parts of each formula can be a huge benefit in learning practical application and growth. I love the instruction given here! LOVE IT!
@nijr3731
@nijr3731 2 жыл бұрын
Amazing! Exactly what I was looking for to help with a project at work! So very well explained, very calm and soft voice to help understand complex tasks, very well informed and explains each step thorough. One of the best Excel tutorials I have ever seen. Will be looking through this channel for other tips! Thank you!
@jancatalinnicoara485
@jancatalinnicoara485 3 жыл бұрын
Excellent explanation Leila. MULTIPLE dependent data validation function should be implemented in Excel as a embedded function (combined by simple one's). Very nice to watch your tutorials. :) Great job.
@davidg.4856
@davidg.4856 3 жыл бұрын
Thank you very much Leila for sharing all your great knowledge. I am actually quite surprised you don't use more (and emphasize) the use of Tables or at least named ranges since they are dynamic and avoid having to use COUNTA(). Furthermore, tables keep formatting and validation rules so no need to add unnecessary rules to empty cells.
@RaiRai031
@RaiRai031 3 жыл бұрын
Hey Leila, I'm a fresh grad mechanical engineer and currently interning in oil and gas company, and my task is to create a database for my engineering department by compiling their previous and current projects, as well as gathering and combining documentations using Excel. Just wanted to thank you for your awesome video for the searchable drop down list (I also improvise it by assigning my macro in that data validation list and it will filter out all the unnecessary data), and eventually later in the future I would need to use this feature for the database. Your contents are truly great, and it allows me to think deeply on how to make my database even better using your video and other sources as references. Hope you have a wonderful day!
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Thank you for the kind feedback! I'm happy the tutorials are useful and you can use the knowledge at your work.
@fastgalix
@fastgalix 3 жыл бұрын
Hey, Apologies if this was mentioned before elsewhere but you can make this somewhat more dynamic, e.g., in the case you want to add a division. The key is to format your division as a table, name it, e.g., TabDivision, and use indirect in the validation list: Validation for the "Select Division" column: =indirect("TabDivision[#Headers]") Validation for the first row (B5) in the "Select APP" column: =OFFSET(INDIRECT("TabDivision[[#Headers],[" & A5 & "]]"), 1, 0, COUNTA(INDIRECT("TabDivision[" & A5 & "]"))) That way you can easily add a division by adding a column to the table and the number of APP is changed automatically by the COUNTA... There are 2 limitations: - The APP in each division is a dense list, i.e., no null value except at the end. - The name of the Table cannot be changed easily as excel will not propagate the change of name in INDIRECT Cheers
@Sparqcorporatetraining
@Sparqcorporatetraining 11 ай бұрын
Excellent! I love your alternative! However, it assumes there's no blanks in between the cells in any column. I think that's why Leila mentioned she preferred this technique. If your columns only have blanks at the bottom it works perfectly! Just thought I'd share that. 🙂
@AlvinRyellPrada
@AlvinRyellPrada 4 жыл бұрын
This is total genius! I literally followed step by step how you do it and i got it! I love how you really explained stuff. Making complex thing simple. Thank you
@LeilaGharani
@LeilaGharani 4 жыл бұрын
Glad it helped Alvin!
@edgy1rocks
@edgy1rocks 2 жыл бұрын
I have found these videos are best watched with two screens and a hand on the pause button. It's slow only going 3 seconds at a time! Wow is this great stuff, though!
@bayarahmed2436
@bayarahmed2436 4 жыл бұрын
Thank you Leila ! As always, perfect !
@jennychen4563
@jennychen4563 4 жыл бұрын
Legend Leila as always!
@GameAGuy
@GameAGuy Жыл бұрын
You are our Excel National Treasure. Apreciate you so much. Sometimes these formulas are so mentally overwhelming.
@waltertrimble1288
@waltertrimble1288 2 жыл бұрын
Hi Leila, thanks for having uploaded such a useful tutorial. You explain things in a crisp and clear manner. The combination of the formulas you showed works out like voodo magic! Please keep up the good work.
@GenerationGap69
@GenerationGap69 4 жыл бұрын
very cool. I'm still working through your essentials course while in lockdown. Stay safe
@binhlephuoc685
@binhlephuoc685 4 жыл бұрын
Great, it's good at always learning to improve yourself event though it's lookdown. Take care!
@MosesKigo
@MosesKigo 4 жыл бұрын
This is my current problem, you have helped so much!
@nbjamspice
@nbjamspice Жыл бұрын
Thank you so much for this tutorial. Your explanation and step-by-step instructions are so easy to follow. I really appreciate your tutorials and look forward to learning new ways to help me do my job more efficiently. It's amazing that there are so many formulas that exist for the laborious and tedious steps we do manually.
@PaulBryanWalkerPBW
@PaulBryanWalkerPBW 3 жыл бұрын
Thank you so much, I am creating a simple address database for our Christmas cards and I want to use an Excel sheet as a database of CITY/STATE/COUNTY. This lesson is exactly what I needed.
@Fatyaqui
@Fatyaqui 4 жыл бұрын
Love this function, thank you Leila. I'm going to play around with it.
@LeilaGharani
@LeilaGharani 4 жыл бұрын
Great. Let us know how it worked out.
@erickbourdin4039
@erickbourdin4039 4 жыл бұрын
Wow amazing mastery of the offset function ! And so clearly explained. Thank you Lady
@LeilaGharani
@LeilaGharani 4 жыл бұрын
Glad you like my take on this Erick.
@davewebster160
@davewebster160 3 жыл бұрын
I needed this solution for the project I’m working on. Awesome as always Leila! Thank you
@mohammadkaif9644
@mohammadkaif9644 3 жыл бұрын
When it comes to any excel query, the only name comes in my mind is of YOURS. All praise is little. Learnt a lot from you. Thank you Leila.
@subratadutta4562
@subratadutta4562 4 жыл бұрын
Excellent, never thought of this. Thanks for sharing.
@LeilaGharani
@LeilaGharani 4 жыл бұрын
My pleasure. Hope it will come in handy for you.
@cyclomaniac9086
@cyclomaniac9086 4 жыл бұрын
This was a good topic to get me going. There are tons of tips in this one. During self-Isolation I’m going to binge watch and work on my Excel skills. Thanks for sharing.
@muhammad_azlyabdulsamat4242
@muhammad_azlyabdulsamat4242 4 жыл бұрын
Thanks.. this sharing wow n wonderful
@FinnJenkins
@FinnJenkins 4 жыл бұрын
Phenomenal usability and exactly what I'm looking for at the moment. Thank you so much.
@LeilaGharani
@LeilaGharani 4 жыл бұрын
You're very welcome Alex!
@rodlourenco
@rodlourenco 3 жыл бұрын
Excellent explanation. Easy to follow and a life saver for me. Thank you!
@mustafapahlovi8993
@mustafapahlovi8993 4 жыл бұрын
Fantastic! Very helpful. Would appreciate if you allow us to know the use of formula for the cases where 4 or 5 dependent columns are there.
@BikashMohantyRocks
@BikashMohantyRocks 3 жыл бұрын
Great method. A query after working around it: After selection of an "app", can we have a dropdown option besides it containing list of values from two specified columns other than the one containing the "app" ?
@MrUni88
@MrUni88 3 жыл бұрын
Wow... indeed u r the best excel tutor ive ever seen... keep ur this great job and thank you 🙏🙏
@lokenng8265
@lokenng8265 4 жыл бұрын
Thank you for the video! You've widen my knowledge in excel!
@dillibabu568
@dillibabu568 3 жыл бұрын
I wonder why would someone dislike such an easily understandable educational video.
@paddymcelligott5375
@paddymcelligott5375 3 жыл бұрын
Haters gonna hate
@joejj6251
@joejj6251 3 жыл бұрын
I think some users aren't keen on using absolute cell references, and prefer using named range. Different strokes for different folks, I guess.
@eltonholmes7848
@eltonholmes7848 4 жыл бұрын
Your tutorials are easy to follow; Thank you for simplifying things.!!
@abdurrehmantariq3752
@abdurrehmantariq3752 4 ай бұрын
Extraordinary! Exactly what I was looking for, very calm and soft voice to help understand complex tasks, very well informed and explains each step thorough. One of the best Excel tutorials I have ever seen.
@VishwasKadrolli
@VishwasKadrolli 4 жыл бұрын
Hi Leila, thank you so much for the video. They really help me to learn and apply to my work related projects.
@greatestever2903
@greatestever2903 4 жыл бұрын
Hi Leila! I love your vids cause of you I’m one of the best Excel users in my office. Question, wouldn’t it be easier and smarter to use the INDIRECT function alongside naming all of these dependant dropdowns with name manager? Just food for thought :) You’re the best!
@marybellandry2975
@marybellandry2975 2 жыл бұрын
I was waiting for Leila to use indirect. Currently, somehow for work onedrive doesn't let me use offset so I use indirect (it's an auto save shared spreadsheet)...
@bharatendudhoundiyal3527
@bharatendudhoundiyal3527 4 жыл бұрын
Thanks for the great help. Instead of using COUNTA to restrict blank cells in list can't we use Ignore Blank option in validation
@Lodgeitude
@Lodgeitude 4 жыл бұрын
The way you teach these methods are digestible, that's what make your videos so will put. Learning from this channel has helped me understand more about Excel. Road to 500k will come sooner than expected. Thanks.
@iwonder3340
@iwonder3340 3 жыл бұрын
had an issue copying the formula to other cells, i have watched a lot of videos on this and you the only person who explained how to do this correctly
@albertoramiroruiz4999
@albertoramiroruiz4999 4 жыл бұрын
LG: "Replace this 15 VERY CAREFULLY..." Me: [flashback to all the times I used the direction key to get to another part of a formula] *single tear*
@cyclomaniac9086
@cyclomaniac9086 4 жыл бұрын
I Know... me too. UGH
@LeilaGharani
@LeilaGharani 4 жыл бұрын
I know that feeling! F2 is your friend here.
@reginaldoxley1430
@reginaldoxley1430 4 жыл бұрын
Leila Gharani I enjoy and have learned a lot from your videos; however, I’d like to suggest explaining why or how a user might want to use what you explaining or demonstrating.
@albertoramiroruiz4999
@albertoramiroruiz4999 4 жыл бұрын
@@LeilaGharani thanks. Tried this yesterday and mind was blown. No more accidental cells selected!
@Creative-Chaos
@Creative-Chaos 4 жыл бұрын
@@LeilaGharani F2? Wow.. I didn't know that. I'm going to try that soon.
@Nyla_emotes
@Nyla_emotes 3 жыл бұрын
For anyone having trouble with pasting the data validation and getting in other rows only the 1st option in the drop down list: after every MATCH COMMAND (there are 2 in the formula) do not lock the cell! So do not write in the formula MATCH($E$2...but leave that unlocked as MATCH(E2 ... and then this will work fine!
@mywork4464
@mywork4464 3 жыл бұрын
An Excel Legend, Truly the best teacher! I have a visual representation of the video that took me quite sometime to make. The goal (Which I do with most of your videos) is to create an instruction / pictorial guide of what you do so that you do no have to watch the video every time, while it might hurt your views it could be something to consider on your premium content. It is similar to your articles but just different enough that it would be an interesting addition in my opinion
@asimali5820
@asimali5820 4 жыл бұрын
LG, You are amazingly great! Very Informative formula and the trick. Thank you for sharing.....
@Shane-nv8og
@Shane-nv8og 3 жыл бұрын
Create named ranges for each list using the name in the column header (Productivity, utility, etc). Use the column headers for the data validation list asshown in the video. Data validation in the dependant cell uses the indirect function refering to the cell containing the column headers which are the same as the range names for the lists. Select the division in the first colum and the list for that division will be available in the second column. Copy to as many rows as needed.
@lagreysinclair5929
@lagreysinclair5929 Жыл бұрын
I use this process too, is much easier for me.
@dinethprabash1001
@dinethprabash1001 3 жыл бұрын
The problem with Validation is after I select the sub-section if I change the Division subsection remains earlier value. Can I reset it?
@eolorvida
@eolorvida 4 жыл бұрын
I like how clear you explained this.
@jawaherath8206
@jawaherath8206 2 жыл бұрын
Leila, Great Job. Your talent to explain every nitty -gritty things in a short time is very impressive. Keep up. Thank you!!!
@rudyniel1702
@rudyniel1702 4 жыл бұрын
Great method ! Normally, I used different tables and I use INDIRECT Function =indirect(name of the table)
@juliusbiliran
@juliusbiliran 4 жыл бұрын
I was about to write this when i read your comment. This is exactly how i do it all the time. It is wayy simpler. 😁
@amgking7243
@amgking7243 4 жыл бұрын
What is the method? Any tutorial for it?
@xposehu
@xposehu 4 жыл бұрын
@@amgking7243 Hey! First drop-down is obvious, just as Leila did it. Before creating the second list, select the whole table (with headers, that is F4:H19), then Formulas Tab, Create from Selection, use the Top Row to create named ranges, Select Column B from B4 downward, then Data Tab, Data Validation, use List and type =indirect(A4) in the source cell. B4 is your active cell, that's why you need to reference A4. In case an error message pops up, click on continue. Indirect refers to now one cell to the left. To get rid of the empty cells, select the whole table again, hit F5 to open the Go to panel, click on Special, select Blanks. Right-click on one of the blank cells, choose Delete and Shift cells up. There you go.
@andyignacio6785
@andyignacio6785 4 жыл бұрын
I've used INDIRECT before. But, I don't like having to name all the ranges and the limitation of not using spaces within the names.
@p018112
@p018112 4 жыл бұрын
@@andyignacio6785 Indirect + substitute will resolve this issue. I only downside would be that you need to name each list.
@mehmetakgul2621
@mehmetakgul2621 4 жыл бұрын
thank you so much for your education video. How can we do this different sheet ?? pls help me for this. Exp: first sheet data, second sheet drop down list...
@ElevatedMochi
@ElevatedMochi 4 жыл бұрын
Yeah I'd like to know too! :D
@bigdogkropp
@bigdogkropp 2 жыл бұрын
YOU are my new favorite Excel Guru, thanks.
@chisnsid
@chisnsid 2 жыл бұрын
Your video tutorials are superb. Thanks. You’ve really helped grow my excel skills. It’s amazing what can be achieved in excel :)
@dr.mansurroy1822
@dr.mansurroy1822 4 жыл бұрын
how do I make 3 or 4 columns with multiple drop downs, each one dependent upon previous column. In this video the multiple columns are dependent upon one set of row.
@mahmoudgomaa3619
@mahmoudgomaa3619 Жыл бұрын
Did u get a way to do that
@charkin9993
@charkin9993 Жыл бұрын
I think you would just replicate the formula for each column, changing the parameters slightly each time to reflect the new data
@laszloberki
@laszloberki 4 ай бұрын
@@charkin9993that’s exactly what I did as well
@dalitsotembo603
@dalitsotembo603 3 жыл бұрын
Am having problems copying the validation to the rest of the column as it keeps referencing to the first cell in the primary column, any help?
@hishoegypt1980
@hishoegypt1980 4 жыл бұрын
Thank you, I've enjoyed with this lesson👍
@christineg.2945
@christineg.2945 3 жыл бұрын
You don't know how grateful I am. I admire your diligence in making these videos. Thank you Leila 😍😍😍🙏🙏
@LeilaGharani
@LeilaGharani 3 жыл бұрын
My pleasure, Christine 😊
@mageshkannashanmuganathan594
@mageshkannashanmuganathan594 4 жыл бұрын
I need help mam. How to make multiple dropdown list which all should be interconnected with each other so that if we change a data from anyone of the dropdown then it should reflect in all like so if any changes in the other dropdown it should reflect in other dropdowns. eg Imagine a list of 4 columns and 4 respective dropdowns are prepared using data validation. If we select a value in dropdown 1 then it should reflect in the other dropdowns (2,3,4) automatically then if we change the value of dropdown 3 then the remaining dropdowns (1,2,4) should be changed. please let this be the next video on coming Thursday, mam.
@martinargimon730
@martinargimon730 4 жыл бұрын
Hi Leila, I have found that the second Combo box drop down list cn be easily populated using the following technique. Do you agree? Define a name called Second_List whose RefersTo property is =INDIRECT("List_"&Sheet1!$L$2) and then use Second_List as the Listfillrange for the second combobox.
@busyshah
@busyshah 4 жыл бұрын
It has a problem that values being referred should not have a space in them
@INVESTLIKEAWOMANPH
@INVESTLIKEAWOMANPH 3 жыл бұрын
I love this video and saved it on my playlist. Thank you so much for this kind of value bombing content! I also like how you explained each step. More power!
@70pjsmith
@70pjsmith 3 жыл бұрын
Hi Leila; As always, your video is clear and concise in the explanation you provide. I had previously tried to adapt your previous related videos to my own data analysis and got stuck (dependent pull-down menu stopped at 20). I discovered this was because I hadn't modified my Offset formula to go beyond the number 20 which you had chosen in your video (correct for your demonstration but not mine!). Anyway, problem fixed and now works beautifully. Many thanks.
@TheGiers
@TheGiers 4 жыл бұрын
Thank you for your explanation. I used a named range for this and could make drop down lists with the INDIRECT() function. However, I would argue that the drop down list in this video is only a single depenent and not multiple dependant since the first list is independent. To get a third row I created an additional table and named each column with "firstChoice_secondChoice". I, again, made named ranges of these columns for the third drop down list. This solution is not very elegant. Is there a better solution to this problem?
@AnkitHadiyal
@AnkitHadiyal 4 жыл бұрын
Can you explain better. I want same for me.
@TheGiers
@TheGiers 4 жыл бұрын
@@AnkitHadiyal My solution is only good for non-dynamic list. The idea is that you create a named list for every posible combination. The first dropdown list is created by choosing a simple list. (i.e. {"Marketing", "Design", ... } For the second dropdown list you create named ranges for each possible option. (i.e. select the options available for "Marketing" and go to "Formulas"->"Define Name" and use the name "Marketing" for the list.) The dropdown list is created with the formula =INDIRECT( R a n g e o f d r o p d o w n 1) For the third dropdown list you create list as in the second step but with names which combine the first and second input (i.e. Name the List "Marketing_London") The dropdown list is created with the formula =INDIRECT(CONCAT( R a n g e o f d r o p d o w n 1, "_", R a n g e o f d r o p d o w n 2 ) (You may have to use SUBSTITUTE(text, " ", "_") as no spaces are alowed in named ranges. Here is an example 1drv.ms/x/s!Asm2HYgDV9E_xkNKAATIcDoenbF8
@TheGiers
@TheGiers 4 жыл бұрын
@@AnkitHadiyal I hope you can use this as it is not dynamic.
@AnkitHadiyal
@AnkitHadiyal 4 жыл бұрын
@@TheGiers thanks, got it.
@danielalejandrorobayo4630
@danielalejandrorobayo4630 2 жыл бұрын
same problem for me, did you find a solution for a really multiple dependent drop down list?, i need at least 6 dependent children columns :(
@wahidulalamrashed8603
@wahidulalamrashed8603 4 жыл бұрын
Good one. I got a problem in pasting the data validation, when I paste the formula in other rows its only giving me 1st option in drop down list Such as If I select Productivitydiv its only give 1st option as Wencal only.
@Unnefable
@Unnefable 3 жыл бұрын
getting the same problem as you, did you manage to figure it out?
@ManishTiwari-rw5vk
@ManishTiwari-rw5vk 3 жыл бұрын
same here, any solutions yet?
@Nyla_emotes
@Nyla_emotes 3 жыл бұрын
after every MATCH COMMAND (there are 2 in the formula) do not lock the cell! So do not write in the formula MATCH($E$2...but leave that unlocked as MATCH(E2 ... and then this will work fine!
@vladimirjovanovich3341
@vladimirjovanovich3341 4 жыл бұрын
Thanks Leila, just another perfect presentation, with easy to follow and understand steps. Your calm and clear voice just adds to the presentation value. Thanks again.
@LeilaGharani
@LeilaGharani 4 жыл бұрын
Thank you so much, Vladimir!
@johnhuoge
@johnhuoge 4 жыл бұрын
Thanks so much Leila, clear and concise, rather than having to learn totally from the ground up. I use to think you must master all the different formula before apply nested formulas, now I just come to specific videos for specific solutions, save me tonnes of time.. love it..!
@LeilaGharani
@LeilaGharani 4 жыл бұрын
Glad it was helpful John!
@Rkeev1
@Rkeev1 4 жыл бұрын
Because offset is volatile Why not place countif(“*?”) in ur formula
@tsgtwright1437
@tsgtwright1437 3 жыл бұрын
or you could use =sumproduct(len(a5:a100)>0) that would skip formulae and only count results
@anasfrh
@anasfrh 4 жыл бұрын
I was rewatching this and I have to say the dynamic arrays formulas really changed the game. Thank goodness.
@LeilaGharani
@LeilaGharani 4 жыл бұрын
They sure did. It really makes things easy now.
@brianchoong7392
@brianchoong7392 4 жыл бұрын
It works! my data validation tore a couple of times on my Mac, but I finally got it when I was more careful to paste over "15"
@LeilaGharani
@LeilaGharani 4 жыл бұрын
That's good to hear. I don't have a Mac in the office so I never know if these things work on it.
@shirishshiroor6204
@shirishshiroor6204 4 жыл бұрын
name the ranges and use if statement in validation =if(a5="Productivity Div", ProdRng,if(a5="Game Div",GameRng,UtilRng)) then copy down
@AI-ec2qb
@AI-ec2qb 4 жыл бұрын
Ive never seen a young woman so smart and beautiful
@raycorcoran137
@raycorcoran137 4 жыл бұрын
you clearly do not know many young women
@kosalanef
@kosalanef 4 жыл бұрын
Hi, its always so pleasant to see how you built the formula structure. very clear explanations and easy to understand. Amazing ! thank you very much. I have a quick note for the "counta" formula. instead of that, we can use the 15 or 20 rows to go down as u said and then use the option given in the data validation "ignore blanks". I did check for this exercise and it shows only the cells with data. Just a suggestion. :) Thank you very much for sharing your knowledge.
@joealexander2181
@joealexander2181 3 жыл бұрын
Excellent Leila, content and delivery. Thank you.
@deepakphadtare
@deepakphadtare 3 жыл бұрын
i admire you leila , yeah its great time every time to have your video on my all excel problems, Thanks Leila
@ignatiusfarm1173
@ignatiusfarm1173 3 жыл бұрын
Thanks so much! love your videos. I had no idea you could copy/paste validation. Used your tabular video to have multiple rows of validation using that formula combo. Cheers
@petrhajek5680
@petrhajek5680 Жыл бұрын
Absolutely awesome!
@bamcabudsan6796
@bamcabudsan6796 Жыл бұрын
Perfect. This is the one that I've been searching for months!!
@suyashshah7628
@suyashshah7628 3 жыл бұрын
You are awesome Leila! You really make it look simple!
@alexsummers6645
@alexsummers6645 4 жыл бұрын
YES! THANK YOU FOR THIS!
@RyDeezy
@RyDeezy 4 жыл бұрын
incredible. this is perfect timing for me. you are definitely a master!
@LeilaGharani
@LeilaGharani 4 жыл бұрын
So glad!
@duhdizzlediz
@duhdizzlediz 4 жыл бұрын
Love your videos BTW! You have helped me with the biggest excel project ever! Noone explains it, like you!!!! Just finished and I have to thank you again!!
@LeilaGharani
@LeilaGharani 4 жыл бұрын
Glad I could help Amanda!
@bradchittenden7967
@bradchittenden7967 3 жыл бұрын
This is a really incredible video. I thoroughly appreciate how you explain these things and make them comprehensible. Thank you!
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Glad you enjoyed it, Brad!
@5ivem608
@5ivem608 Жыл бұрын
i learn from you and make 3 and 4 multiple dependent drop-down list in same sheet 🥰🥰🥰
@jaanaan2847
@jaanaan2847 Жыл бұрын
Thanks, Leila, your teaching is amazing! step by step you explained everything. I subscribed and want to watch most of your videos. Very helpful!
@zahidmaqbool19
@zahidmaqbool19 4 жыл бұрын
Simply a great approach I must say.
@AnthonyEnglish
@AnthonyEnglish Жыл бұрын
Hey Leila, I've bought your XELPLUS course Excel Essentials for the Real World and it's got incredible value for an extremely low price. It's just like your KZbin videos - very clear and step by step. Little hint about your timestamps in the comments on this video: there are two sets of timestamps, which means chapters won't appear correctly when people want to jump ahead to the relevant section in the video.
@mfzasr5665
@mfzasr5665 3 жыл бұрын
Your explanations are super simple and easy to understand. Subscribed ✅
@Aufu7ara
@Aufu7ara 4 жыл бұрын
Excellent! It really helped me a lot. I can't thank you enough Ms Leila...
@LeilaGharani
@LeilaGharani 4 жыл бұрын
You're very welcome!
@gouthamramdas1908
@gouthamramdas1908 Ай бұрын
I spent hours trying to figure this out, till i came across your page. THANK YOU SO MUCH FOR THIS VIDEO. It was easy to understand and follow along.
@globtex
@globtex 4 жыл бұрын
wow, great i just love it... there are many ways to get multiple dependent lists.... but to me this is #1 option. keep goin... fantastic.
@LeilaGharani
@LeilaGharani 4 жыл бұрын
Thanks a lot 😊
@ratuldas4347
@ratuldas4347 9 ай бұрын
Thanks a lot Leila for the video, awesome support!
@muhmoodzubair4571
@muhmoodzubair4571 3 жыл бұрын
Hi Leila, this video is just a gem!! NEver thought this could be done. Thanks very much!!!!
@gracebarnes1377
@gracebarnes1377 2 жыл бұрын
One of the best video on internet for hosting! ❤️❤️
@DinoDelight
@DinoDelight 2 жыл бұрын
Perfect, just what I was looking for. worked like a charm 👏👏👏
@agungparasara9261
@agungparasara9261 4 жыл бұрын
thanks, you are a legend leila
@vividinspiration6365
@vividinspiration6365 Жыл бұрын
Thank you for this! This was so easy to follow and gave me exactly what I needed!
@gopalakrishnanmanikandan6520
@gopalakrishnanmanikandan6520 Жыл бұрын
Simple, yet useful. Thank you so much for this video.
@shiffamohammed5818
@shiffamohammed5818 2 жыл бұрын
Great content and great explanation, thank you so much Leila!
@michaelstamos5510
@michaelstamos5510 Жыл бұрын
WOW - Leila - Thank you - you are an amazing educator and have helped me immensely - all the best to you in your life
@19hummer73
@19hummer73 3 жыл бұрын
Thank you for sharing your knowledge ❤️
@careerspack
@careerspack 4 жыл бұрын
Your Channel @Leila is th first thing comes to mind when facing an issue with Microsoft excel. Keep up the good work!
@LeilaGharani
@LeilaGharani 4 жыл бұрын
That's great. I'm glad you find the videos useful.
@margheritalanfredi8100
@margheritalanfredi8100 2 жыл бұрын
Wow, this formula is amazing! Thank you!
@naboulsikhalid7763
@naboulsikhalid7763 4 жыл бұрын
great tutorial, love to be a follower. thank you
@brilliantlights
@brilliantlights 10 ай бұрын
Excellent tutorial. Thank you. Thumbs up.
@efraimnazario8940
@efraimnazario8940 4 жыл бұрын
Thank you for sharing this!
Create Dependent Drop Down List in Excel - EASY METHOD
12:10
Kevin Stratvert
Рет қаралды 33 М.
Make Multiple Dependent Dropdown Lists in Excel (Easiest Method)
10:59
Is it Cake or Fake ? 🍰
00:53
A4
Рет қаралды 19 МЛН
Homemade Professional Spy Trick To Unlock A Phone 🔍
00:55
Crafty Champions
Рет қаралды 55 МЛН
Must-have gadget for every toilet! 🤩 #gadget
00:27
GiGaZoom
Рет қаралды 10 МЛН
Create SMART Drop Down Lists in Excel (with Data Validation)
15:42
Leila Gharani
Рет қаралды 834 М.
Excel Time-Savers - 5 Hidden Features for Busy People
14:24
Leila Gharani
Рет қаралды 358 М.
Return Multiple Match Results in Excel (2 methods)
14:13
Leila Gharani
Рет қаралды 1,9 МЛН
Dynamic Excel Drop Down Lists - PLUS how to get SEARCHABLE Drop Down Lists!
10:02
Dependent Drop Down List in Excel Tutorial
11:10
Kevin Stratvert
Рет қаралды 597 М.
When Should You Use the Hash Sign in Excel Formulas?
10:53
Leila Gharani
Рет қаралды 1 МЛН
Make Beautiful Excel Charts Like The Economist (file included)
19:07
Leila Gharani
Рет қаралды 363 М.