J
JulieD
Hi All
trying to implement data validation where the number entered must be 1
greater than the maximum value in a dynamically defined range.
e.g. mylist is defined as =OFFSET(Sheet1!$A$1,0,0,Counta(Sheet1!$A:$A),1)
and i want to say that the value must be a whole number equal to
=MAX(mylist)+1
Cheers
JulieD
trying to implement data validation where the number entered must be 1
greater than the maximum value in a dynamically defined range.
e.g. mylist is defined as =OFFSET(Sheet1!$A$1,0,0,Counta(Sheet1!$A:$A),1)
and i want to say that the value must be a whole number equal to
=MAX(mylist)+1
Cheers
JulieD