Forum Discussion
Data validation lists - flow chart?
Hello Phoebe,
What you need is a dynamic dependent drop-down list. In the attached file, I inserted Lists sheet. You can add (or delete) categories of Dimensions of Depth and Dimension Focus. There is no more need to define additional named ranges.
Hello Phoebe,
What you need is a dynamic dependent drop-down list. In the attached file, I inserted Lists sheet. You can add (or delete) categories of Dimensions of Depth and Dimension Focus. There is no more need to define additional named ranges.
I like the strategy that prevents the user from changing the 'dimension of depth' whilst the dependent category is non-blank. I also note that your formula also accommodates varying length lists dynamically.
Where our objectives differ, is that I set out to eliminate all direct referencing and replace them with structured references or defined names. I have come to be of the opinion that identifying a data value by its location relative to the formula [A1 or R1C1] is an abomination that has no place in serious calculation. All the more irritating that it was done intentionally in VisiCalc "One could do it the programmer's way [using named variables] but that would be tedious".
p.s. I do realise that, in the main, Excel is used for purposes other than 'serious calculation'. The fact that over 90% of spreadsheets are erroneous probably doesn't matter.