Drop down menues

Hi all,

I cannot work this one out and wondered if anyone can help.

I know how to create dropdowns and dynamic dropdowns, but want i need is a dropdown that shortens the options on a second dropdown.

the maximum combined value is 5, so if they chose 3 from the first dropdown list, then the second dropdown list to only show (in this instance) 0, 1 and 2. is this at all possible.

thanks wayne

Yes its possible

First list a2:a7
0
1
2
3
4
5

if the cell with the first dropdown in in b1 with validation by list a2:a7

second dropdown validation list
=OFFSET(A1,0,0, MATCH(6-B1,A2:A7,0),1)

ty Davsth that worked perfectly