Forum Discussion
Solved
Set the value of a cell within a range and change it automatically
Hello to everyone! I have seen that you can set a data validation for a cell, so if you want the value of that cell to be within a range, an error message would appear. What I want is to set a v...
Maybe something like this dynamic dropdown will work. It will list out all of the numbers between 1 and the Maximum that you specify. See attached .xlsx file for an example.
It uses this data validation formula: =OFFSET($E$1,0,0,B1,1)
Greetings!
As understood, please find .xlsx.
Thanks,