An awesome simple explanation of HOW TO BUILD a robust multi row dependent drop down list in Excel
I realised after recording that Mark suggested this exact solution at the start of our UNPIVOT podcast and I didn't realise until listening back to the podcast a few days later.
Hear the discussion [ Ссылка ]
⏬ Download the file:
[ Ссылка ]
Mark’s video
[ Ссылка ]
My previous video of “easiest dependent drop down list”
[ Ссылка ]
00:00 the aim
00:48 table set up
02:13 range name set up
04:00 the magic XLOOKUP : XLOOKUP
09:00 conditional formatting to flag invalid choices
11:12 if you can’t rely on a sorted table
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. [ Ссылка ]
Did you know I've written a book "Power BI for the Excel Analyst"?
[ Ссылка ]
Connect with me
[ Ссылка ]
