Multi select dropdown lists in Google Sheets & unpivot for analysis
Google Sheets introduced multi select drop down lists, I go through how to make them and more importantly how to analyse the results from them, which involves some complex formulas.
How to make them is in the first 90 seconds but how to analyse them comes later to make this video longer.
To download example workbooks, enter email here: https://www.xlconsulting-asia.com/soc...
Some other related videos:
QUERY function: • QUERY Complete guide: Google Sheets' most ...
Unpivot with FLATTEN: • Unpivot in Google Sheets with FLATTEN: Col...
Dynamic arrays in G Sheets: • Google Sheets: Dynamic Arrays - SORTN, SPL...
Data validation/dropdowns: • Colour dependent dropdowns, ticks & NEW Go...
00:00 Introduction
00:19 Multi select drop downs
01:37 Limitations
02:40 Split into multiple cols
04:28 Search for contains
06:00 Unpivoting via complex functions