Multiple Dependent Drop-Down List in Excel | NEW Simple Method | Works with multiple rows

แชร์
ฝัง
  • เผยแพร่เมื่อ 24 ธ.ค. 2024

ความคิดเห็น • 55

  • @JustineHernandez-SWHTX
    @JustineHernandez-SWHTX 4 หลายเดือนก่อน +2

    This is the most incredible, easy, dynamic dependent dropdown solution I've ever seen. THANK YOU SO MUCH.

    • @RebekahOster
      @RebekahOster  4 หลายเดือนก่อน

      Wow, that is such high praise! Thanks for watching 😁

    • @blossomkeepsake4240
      @blossomkeepsake4240 หลายเดือนก่อน

      Hi Thanks so much for this it’s so easy - but what if I wanted to add the same colour twice in the same level? Just to put this into context I’m working in birthstones and someone might want to add garnet, amethyst, garnet? Many thanks!

  • @sohailjafri1423
    @sohailjafri1423 25 วันที่ผ่านมา

    Hats 👒 off!
    Brilliant excel expert!

  • @ElieROCfitness
    @ElieROCfitness 3 หลายเดือนก่อน

    It was killing me trying to find what I wanted with so many vids showing 2 validations or horizontal lists. Your was exactly what I wanted and easy to understand your logic. Thank you so much !!

    • @DataDashPro
      @DataDashPro หลายเดือนก่อน

      I cover similar method with smart indirect. th-cam.com/video/KyxBV2y-zW8/w-d-xo.html

  • @aurielsmith8753
    @aurielsmith8753 3 หลายเดือนก่อน

    Thank you - this tutorial was very helpful - was getting a bit confused with the Options and Working titles being the same but I got used to it. Thank you very much for sharing .... much appreciated

  • @paulgilbraith2650
    @paulgilbraith2650 หลายเดือนก่อน

    This worked great!!!! Thank you for the detailed yet simple instructions. The only issue I had was I did not have the =torow formula available in Office 2021, so I just substituted it using the =transpose formula.

  • @bvignesh
    @bvignesh 3 หลายเดือนก่อน

    Absolutely Amazing and Super Clear Explanations. Had it implemented on my use case today ! 👍

    • @DataDashPro
      @DataDashPro หลายเดือนก่อน

      I cover similar method with smart indirect. th-cam.com/video/KyxBV2y-zW8/w-d-xo.html

  • @fliptop157
    @fliptop157 3 หลายเดือนก่อน

    I'll be using this to automate my time sheet as I work with several charge numbers under different projects. Thanks!

  • @Enthusiastic_Engineers
    @Enthusiastic_Engineers 5 หลายเดือนก่อน +3

    If the working table and Option table are in two different sheet of a workbook. Please share the changes in formulas to be put.

    • @DataDashPro
      @DataDashPro หลายเดือนก่อน

      I cover similar method with smart indirect. th-cam.com/video/KyxBV2y-zW8/w-d-xo.html

  • @Sourabhabiyanta
    @Sourabhabiyanta 21 วันที่ผ่านมา

    Thanks alot

  • @miloradvranjkovic6162
    @miloradvranjkovic6162 หลายเดือนก่อน

    Hi Rebekah, thank you for providing that example. One question I have: I plan on creating this for an excel sheet that will have thousands of lines. Will all these filter equals slow down the workbook too much?

    • @DataDashPro
      @DataDashPro หลายเดือนก่อน

      I cover similar method with smart indirect. th-cam.com/video/KyxBV2y-zW8/w-d-xo.html

  • @drmojoluv
    @drmojoluv หลายเดือนก่อน

    Is there a way to do this with the "Options" (data) on a separate workbook?

    • @DataDashPro
      @DataDashPro หลายเดือนก่อน

      I cover similar method with smart indirect. th-cam.com/video/KyxBV2y-zW8/w-d-xo.html

  • @stanTrX
    @stanTrX 2 หลายเดือนก่อน

    Thanks. I will try it. How about data consistency if level 1 is changed? Any vba free method to do it? Conditional formatting warning maybe? Or something smarter?

    • @ShivAadesh
      @ShivAadesh หลายเดือนก่อน +1

      Using Name Manager

    • @stanTrX
      @stanTrX หลายเดือนก่อน

      @@ShivAadesh ok but how?

  • @michellebrown7527
    @michellebrown7527 5 หลายเดือนก่อน

    This is great! Is there a way to have the last level auto populate?

  • @blossomkeepsake4240
    @blossomkeepsake4240 หลายเดือนก่อน

    Hi Thanks so much for this it’s so easy - but what if I wanted to add the same colour twice in the same level? Just to put this into context I’m working in birthstones and someone might want to add garnet, amethyst, garnet? Many thanks!

    • @DataDashPro
      @DataDashPro หลายเดือนก่อน

      I cover similar method with smart indirect. th-cam.com/video/KyxBV2y-zW8/w-d-xo.html

  • @brokenbird2012
    @brokenbird2012 8 หลายเดือนก่อน +1

    Hi Rebekah! Really good method. I am having issue on the first step with the indirect function in the Data Validation. It works but i am still getting all the duplicates. Excel Version I have is Excel 365. No sure my its not working. I would appreciate the Help. Thanks!

    • @RebekahOster
      @RebekahOster  8 หลายเดือนก่อน +1

      Hi! Thank you for your comment!! I've done a little investigating, and it seems like this was a "secret" feature that came along with AutoComplete for Drop Down Lists. It could be that it's just not released for your Office 365 channel. I'm sorry! For Level 1, you could set up a helper column with =UNIQUE(Options[Level 1]). Then reference that cell in the Data Validation Source, just like I demonstrate for Levels 2 and 3.

    • @101ckin
      @101ckin หลายเดือนก่อน

      @@RebekahOster Hiii, im geting the same issue, can u explain further where should i put the " =UNIQUE(Options[Level 1])" is it in the data validation part?

  • @oxablon
    @oxablon 3 หลายเดือนก่อน

    Great tutorial...Wish I followed this one first :) Anyway to transpose this ?

  • @TechGuyZone
    @TechGuyZone หลายเดือนก่อน

    Awesome! Thank you.

  • @ziyamoustafa4951
    @ziyamoustafa4951 6 หลายเดือนก่อน

    Fantastic! Very clearly explained.

  • @shdt-videos
    @shdt-videos 5 วันที่ผ่านมา

    How can we do this in google sheets?

  • @tempatsuratfahmi3795
    @tempatsuratfahmi3795 14 วันที่ผ่านมา

    Terima kasih banyak

  • @SaeedFarrokhi
    @SaeedFarrokhi 21 วันที่ผ่านมา

    Easiest method ever.

  • @jackandrews5829
    @jackandrews5829 7 หลายเดือนก่อน

    Working on the formula for level 3. I am running into an issue where the 'working' tag is autogenerating when I select columns. If i manually type the code in, then excel doesn't recognize the formula as valid. But I am an excel newbie, so I could be doing something very silly. Anything thought on how to get the ' (Working[@[ ' portion of the formula to get added and to work?

    • @RebekahOster
      @RebekahOster  7 หลายเดือนก่อน

      Hello! Thank you for watching! It sounds like your Working data isn't formatted as an Excel Table. Using an Excel Table allows for Structured References aka using the square brackets to name the exact column. To do this, select anywhere on the data and click Insert -> Table. Then in the Table Design tab, name your table "Working" or whatever you want 🙂 If you want to see this in action, check out the free training here: www.excelpowerup.com/training

  • @sharonsiekay4966
    @sharonsiekay4966 หลายเดือนก่อน

    For mine when I put another colour below the first colour it does not choose the level 2 options

    • @DataDashPro
      @DataDashPro หลายเดือนก่อน

      I cover similar method with smart indirect. th-cam.com/video/KyxBV2y-zW8/w-d-xo.html

  • @VT-xt3vi
    @VT-xt3vi 6 หลายเดือนก่อน

    Hello, this video was super helpful for me, thanks for sharing it! I created 3 dependent lists with lots of options within each list. I'm running into a problem though: as I get further down into my spreadsheet and choose from my first list I start loosing the different options I have in the second and third dependent lists that I used to see towards the beginning of the spreadsheet. I think this is because as I go down the possible options for each dependent list the formula goes down one row and the options start to get used up, so I'm left with less options to choose from each list. Would you know how I can fix this!? I tried copying and pasting the formula to each cell under the drop-down "Helper" instead of dragging down like you did, but that ends up only limiting me to the first thread of options of the dependent lists...I hope this explanation makes sense...Thanks!

    • @RebekahOster
      @RebekahOster  5 หลายเดือนก่อน

      If I'm understanding correctly, the problem may be with the cell references. Like you said, when you go down the options start to get used up. In the video I always use Structured References, which are available if you are using Excel Tables. They look like this: Options[Level 2]. That will grab all the cells in the Level 2 column. And even when the formula is dragged down, the selection won't change! If you just selected that range though, and it looks like this: A2:J10, when you drag the formula down, it will change to A3:J11. (those cell references are made up, so I hope it makes sense!) The #1 solution is to convert your options data into an Excel Table. Check out my free training for more info (www.excelpowerup.com/training) ! You could also convert the references from relative to absolute by adding dollar signs like this: $A$2:$J$10.

  • @ziggle314
    @ziggle314 8 หลายเดือนก่อน

    Nice job. Thanks!

    • @RebekahOster
      @RebekahOster  8 หลายเดือนก่อน

      Thanks for watching!

  • @mayur_kumar
    @mayur_kumar 8 หลายเดือนก่อน +1

    What not use a Pivot table?

    • @RebekahOster
      @RebekahOster  8 หลายเดือนก่อน

      Hi! Thanks for your comment 🙂 A PivotTable would be used to summarize data. This tutorial is for a method to speed up data entry. They are just different applications!

    • @mayur_kumar
      @mayur_kumar 8 หลายเดือนก่อน

      @@RebekahOster That makes a lot of sense. But it is a good video and has its place.

  • @almarspeelberg7214
    @almarspeelberg7214 17 วันที่ผ่านมา

    This solution works but has the handicap that for every row in your worktable you create data in the two helper tabels. For smal files no problem but for excel files with thousands of rows you create la lot of data that's not going to be used anymore. That can be a great handicap!

  • @Techmava2
    @Techmava2 3 หลายเดือนก่อน

    Insightful

  • @jpete190
    @jpete190 5 หลายเดือนก่อน +1

    JEEZ, WHT A NIGHTMARE.

    • @RebekahOster
      @RebekahOster  5 หลายเดือนก่อน +2

      I agree that this seems complicated! But it’s definitely the simplest method I’ve found. And could be very useful to some people 😁

  • @abdelazizallam
    @abdelazizallam 8 หลายเดือนก่อน

    thanks

    • @RebekahOster
      @RebekahOster  8 หลายเดือนก่อน

      You're welcome! Thank you for watching and commenting 😀⚡

  • @MoustafaMahmoudElmasry
    @MoustafaMahmoudElmasry 6 หลายเดือนก่อน

    you are awesome

  • @veruscrt
    @veruscrt 8 หลายเดือนก่อน

    It's too complicated for me to learn, so I just apply it.😁

    • @RebekahOster
      @RebekahOster  8 หลายเดือนก่อน

      😉 How do you use dependent drop-down lists?