WTC_Services
asked on
Data Validation List with variable
How to make a drop down list using numbers from 1 to x. x is a variable that can be set.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
There is an option in Data Validation for Whole Numbers whereby you specify the Minimum and maximum values. Each of these can be linked to a cell so you can set the Minimum to 1 if so required and link the maximum to a cell to give the variable maximum.
When using Data Validation for a range of numbers it doesn't give the option for a drop down list like text entries do.
Alternatively, you could create a list starting at 1 and using an IF statement to increment by 1 if smaller than Maximum and then create a Dynamic named range on that list to use as a list option for the DV.
Thanks
Rob H