Excel self-updating Drop Down List for Data Validation

⏬ Check out the description for info and links⏬


Download the file here: https://aasolutions.sharepoint.com/:f...


A more detailed video on different dynamic array functions including VSTACK and HSTACK    • Wow... Amazing Excel TEXTSPLIT, HSTAC...  




00:00 Intro
00:21 The End Goal
01:56 SORT UNIQUE
02:16 Exclude Flag using ISNUMBER( XMATCH
03:40 FILTER Excluded Items
04:15 VSTACK to combine orignal table with new items
04:56 Adding an error handler when table is blank
05:55 Creating the Drop Down list via Data Validation List
06:34 Flag if a new item has been added





Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/


Connect with me
https://wyn.bio.link/
https://accessanalytic.com.au/