Create a multi-level dropdown list to fill in province, district, sub-district, and postal code.

This video will teach you how to create a multi-level dropdown list to enter province, district, sub-district, and postal code information in Excel 365. What's special about this video is that it's a multi-level dropdown list, allowing you to create multiple entries for each line of sales data. You'll also learn about Excel 365's dynamic array functions, such as UNIQUE, SORT, FILTER, TRANSPOSE, and # references. Download the accompanying file: https://github.com/ThepExcel/YouTube/... ********** There's a small error in this video. I forgot that in Thailand, district/sub-district names can be repeated, causing the displayed postal code numbers to be exaggerated. I've shown you how to fix the formula at    • วิธีแก้ไขสูตรคลิปก่อนหน้า กรณีชื่อตำบลซ้ำก...   The formula is as follows: ================ Province Name: =SORT(UNIQUE(PostCodeTable[ProvinceThai])) District Name: =TRANSPOSE(SORT(UNIQUE(FILTER(PostCodeTable[DistrictThaiShort],PostCodeTable[ProvinceThai]=H5,"Please select a province")))) Subdistrict Name: =TRANSPOSE(SORT(UNIQUE(FILTER(PostCodeTable[TambonThaiShort],(PostCodeTable[DistrictThaiShort]=Sheet1!I5)*(PostCodeTable[ProvinceThai]=Sheet1!H5),"Please select a district")))) Postal Code : =TRANSPOSE(SORT(UNIQUE(FILTER(PostCodeTable[PostCode],(PostCodeTable[TambonThaiShort]=Sheet1!J5)*(PostCodeTable[DistrictThaiShort]=Sheet1!I5)*(PostCodeTable[ProvinceThai]=Sheet1!H5),"Please select a sub-district")))) ***** If you like this video, please subscribe to my YouTube channel to help me reach 100K subscribers ^^ ======================================================= Follow, chat, and ask questions about Excel at:   / thepexcel   Read great Excel articles at: https://www.thepexcel.com/ Online Courses from Excel Experts ======================= Excel Level Up Course (Basic-Intermediate): https://bit.ly/Excel-Level-Up-Online-... Excel Power Up 2021 Course: https://bit.ly/thepexcel-power-query-... Powerful Data with Power BI Course: https://bit.ly/powerful-power-bi-online Power BI DAX Advance Course: https://bit.ly/ThepExcel-DAX-Advance Create Magical Formulas with Array Formulas: https://bit.ly/ThepExcel-ArrayFormula See all courses here: https://www.thepexcel.com/training-pe...