Hi
Define those various lists a named ranges, p.e. List1, List2, ..., List6
Let you have your total be in cell A7
For next data validation list, set source to:
=CHOOSE(INT(MAX(1;(C1+5)/6)),List1,List2,List3,List4,List5,List6)
(You can have up to 24 various lists to select from in formula)
Arvi Laanemets
"Neal" <neal_@_ap0yar_dot_co_dot_nz wrote in message
...
Hi there
We have a sheet that allows people to select items from a list. Each item
they pick has a value associated. There are 6 rows of this, then a total
appears.
The next combo box list text depends on the total from the previous
choices.
If they score from 0-6 the first list should appear, from 7-12 a different
list appears etc
How can we do this? At the moment we are using Excel 2003 and Data
Validation Lists, but not sure if this will do what we want.
Regards, Neal.
|