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:/s/PubliclyAvailableContent/Eo2OQnBuKJBEtFcqh5jtuOoBddnB2q3VixLAMVeAudx8MQ?e=nutkbQ A more detailed video on different dynamic array functions including VSTACK and HSTACK https://youtu.be/0hggasS-uYM 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/