Комментарии:
Life-saver to find this again. A whole lot of help it is, thanks.
ОтветитьTHIS DOESNT WORK WHEN THE DATA VALIDATION IS MADE IN A TABLE, CAN U HELP
ОтветитьHi @leilagharani . theres any video of dependent lists based on id columns instead of header columns? Meaning I got A columns with the id and b column (categoryid and category name) with the display text, and another table with the id and let's say productid and product name. that could be helpful. Thanks in advanced
ОтветитьWhat happen in case is whe create three level dropdown menu. Everything look ok but.... if same values in second column appears in two different values from first column?
ОтветитьThank you ❤
ОтветитьWhich means this does not work with named ranges (CTRL + T)?
Ответить1000 thumbs Up
ОтветитьHi. Thanks. Is there a way to have a blank cell when you change to a new division? I noticed the last selection remains
ОтветитьThank you for the video tutorial, i tried the approach but when we copy the formula to D6 , E6 shows the values filtered in E5 its not refreshing
ОтветитьHi leila..my doubt is..assume that there are 5 categories of reasons viz. Financial, Statutory, Accounting, Documentation, Others. I created a dropdown list using these names. The first 4 names have their reasons (i.e.) if I click financial , in the adjacent cell I get the list of reasons related to "Financial"..i did this using "Indirect" function...the problem is when I click the last category ("Others")... I want to type my own reasons...but when I type in the adjacent cell Excel shows me error dialogue box...How to solve this issue? Please help me...I'm waiting for your response❤
ОтветитьHow can I do this with multiple rows?
ОтветитьCould you please make a video showing, choosing from drop down list, Country then State, then District, then city. Selecting country should list only states (provinces) in that country only, like that, selecting province should show districts in that province only. Thanks very much for your videos.
ОтветитьThis is working fine when Division is ordered one by one, But "Division" is Unorder or Shuffle, do you have any solution!?
ОтветитьThank you for this, I have learnt something new. You got yourself a like and new subscriber
ОтветитьGreat clear tutorial for what is a great spreadsheet design element. Might want to include a brief explanation on how to get around the Data Validation formula bar not recognizing Table and column names as in the comments below from German Vargas, Carla V and Rene Oldenhoff.
ОтветитьHi... how do we replicate the same in Google Sheets??
ОтветитьThanks a lot, it's amazing and so helpful. Brief and concise.
ОтветитьPlease explain,
If division remain un-order list, then what should we do?
Excellent👍👍👍
Ответитьthank uuuuuuuu
ОтветитьYou save my life for 1000th time, keep it up with the great work! Love your content!
ОтветитьThank you so much for the tutorials. Can I do this automatically in town, city, and country?
ОтветитьThis is too good. Really helpful
ОтветитьI owe you 👌👌👌
ОтветитьVery good stuff! I'm stuck in the last part where we're inputting the function in the data validation. It keeps telling me that there's a problem wiht the formula, even though I get the list I want when pressing F9 (prior to data validation). Any thoughts?
ОтветитьExcel won’t let me copy formula into data validation list
ОтветитьYour voice is so cute
ОтветитьLeila please make video of this for every row. Love you
ОтветитьExactly what I'm searching for. Thank you very mush, you are my Saviour!! Great work there, will share with my friends.
ОтветитьWhat if the Division are not entered serially? I mean if the list starts with productivity and then right after productivity game division entered and then productivity again and so on.
ОтветитьThanks - very helpful
ОтветитьThanks Leila. I see this is an aged video so not sure if I can comment to get help. I have a similar list but my requirement is, I need to be able to see the entire list. Ex.: If I select " Productivity", I want to see all Apps mapped under it. So and so forth for Game and Utility. What's the way?
Ответитьworks perfectly when the column A has consecutive values. The only thing I wonder is how to implement if division names aren't consecutive?
Ответитьthanks thanks
ОтветитьAwesome, thanks, Leila.
ОтветитьGreat Video! Now I have to figure out how to expand the same principle for more consecutive columns. My Programm has 4 consecutive dependent drop down lists referring to one big exercise database (Exercise category -> Subcategory -> Difficulty -> Exercise Name). For each Subcategory there is 4 Levels of difficulty (beginner, intermediate, advanced, expert), which are repeating accordingly throughout the whole range of this column. Any Ideas how to solve that without creating a hundreds of Range Names?
ОтветитьHow do I do this with three or four columns rather than two? It would have a filtering effect so each column completed would reduce the option for the next column(s).
Ответитьgetting frustrated maybe you can help me...
I am trying to do, is use a current `(LIST) drop down, and fill in a cell beside it with correct fill in a number format,.
so I am trying is the following, have a drop down box to choose an item, and have the cell beside to fill in with number that is associated to the drop down box
When the Divisions are not in order, this does not work. Any idea how to address that issue?
ОтветитьGot the idea in this video. Very nicely explained, but what to do if I need to have the dependent dropdown list with unique values.
Ответитьworks perfectly well so far. The only thing i wonder is how to implement if division names aren't consecutive?
ОтветитьHi Leila ,
I am working on something similar but my data and dropdown is in two different sheets of the same file . I am getting “source currently evaluvates to a error” msg.
Hi Leila! I love your videos and I have been learning a lot from them. I have a question. I have been trying to use the UNIQUE($A$4:$A$43,FALSE) formula to feed the Data Validation list but with no luck. I even created a Name with the formula but the Data Validation keeps giving the error "The Source currently evaluates to an error. Do you want to continue?"
What puzzles me is that I can use an INDEX() formula to feed the Data Validation list, but I cannot use UNIQUE() to accomplish the same. Is there a way to use the UNIQUE() formula to feed the Data Validation list? I appreciate your help.
Hi I have copied the formula exactly replace my own field and I keep getting an error that I have entered to many arguments for this function is have I missed something or is there a limit to the function, I know it is a couple of years since you posted this and excel may have changed in that time. I have 24 Suppliers and 97 products and just want the products for the selected supplier to show in the second drop down. Any guidance would be apricated at this stage
Ответить