Even easier than easiest - Multi Level Dependent Drop Down Lists скачать в хорошем качестве

Even easier than easiest - Multi Level Dependent Drop Down Lists

★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid.com/academy ★ Get the example file ★ Sign up for our free Insiders program and get the example file: https://exceloffthegrid.com/insiders-... File Reference for this video: 0238 Even easier dependent drop down lists.zip ★ About this video ★ We have looked at easy methods for multi-level dependent dropdown lists before. But this video includes an even easier method. So... if you're ready, let's get started. 0:00 Introduction 0:16 Scenario 1:10 Creating dropdown lists with the DDL function 3:04 What is the DDL function? 4:23 How to get the DDL function? 5:47 Grouping data with the DDLSorter function 7:12 Wrap-up Wyn Hopkins Video:    • THE Easiest Multi Level Drop Down Lis...   My Previous Video:    • Easiest Multi-Level Drop-Down Lists i...   💻 DDL Function: =LAMBDA(range,[lookup1],[lookup2],[lookup3],[lookup4],[lookup5],[lookup6],[lookup7],[lookup8],[lookup9],[lookup10], LET( _s, "%^&&@", lookupValue, lookup1 & _s & lookup2 & _s & lookup3 & _s & lookup4 & _s & lookup5 & _s & lookup6 & _s & lookup7 & _s & lookup8 & _s & lookup9 & _s & lookup10, levelIndex, IFERROR(ROWS(TEXTSPLIT(lookupValue, , _s, TRUE())), 0) + 1, lookupArray, BYROW(EXPAND(CHOOSECOLS(range, SEQUENCE(1, levelIndex - 1)), , 10, ""), LAMBDA(row, TEXTJOIN(_s, FALSE, row))), returnRange, INDEX(range, 0, levelIndex), result, IF(ISOMITTED(lookup1) * levelIndex = 1, returnRange, XLOOKUP(lookupValue, lookupArray, returnRange):XLOOKUP(lookupValue, lookupArray, returnRange, , , -1)), result)) 💻 DDLSorter Function: =LAMBDA(Range,[SortOrder],SORT(Range, SEQUENCE(, COLUMNS(Range)), SortOrder)) ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter:   / exceloffthegrid   #MsExcel