Question about validation lists

  • Thread starter Thread starter Gotroots
  • Start date Start date
G

Gotroots

What causes the validation list to change the range to add one or more empty
cells to the end of the list. When playing round with the defined Name
formula I notice it can change the range to include empty cells. Anyone got
any thought on this?

=OFFSET(Sheet3!$F$1,0,0,COUNTIF(Sheet3!$F:$F,"?*"))
 
What is your reason for using
COUNTIF(Sheet3!$F:$F,"?*")
instead of
COUNTA(Sheet3!$F:$F)

In column F do you have any cell that just conatin blank characters / empty
spaces...
 
The reason for using such a formula is that the range contains values that
are the result of a formula. No blanks occur until the end of the list,
however any empty cells thereafter will contain a formula.
 
Back
Top