I apologise if this is not a formula/function problem.
I want users to select a "low" number from a drop down list in G2
(I have set this up using data validation using a named range that includes the numbers 1 through 12)
Then I want the user to select a high number from a drop down list in G3
Is it possible to force the drop down list to only include numbers equal to, or greater, than the number selected in G2 through to a maximum of 12
ie can I force a way for the choice in G3 to NEVER be less than the choice in G2?
Example 1:
In G2 the user chooses "3"
In G3 the user is presented with a drop down list of only 3, 4, 5, 6, 7, 8, 9, 10, 11, 12
Example 2:
In G2 user chooses "8"
In G3 the user is presented with a drop down list of only 8, 9, 10, 11, 12
I tried using dependent data validation but because the categories in G1 are numbers, I can't use the name of a range as a number
Perhaps there is a more elegant solution than my feeble Excel experience can think of?
Many thanks for any solutions/guidance.
Bookmarks