Validation - clear blanks from drop down
Blank cells are at the end of the range.
The formula in the 'name' range was the same as Debra's suggestion (with
columns changed). The formula in the select cell is as below
=IF(ISERROR(INDEX($T$1:$U$62,SMALL(IF($T$1:$T$62=$ W$1,ROW($T$1:$T$62)),ROW(3:3)),2)),"",INDEX($T$1:$ U$62,SMALL(IF($T$1:$T$62=$W$1,ROW($T$1:$T$62)),ROW (3:3)),2))
--
Hayley
"Biff" wrote:
Hi!
Are the blanks cells scattered within the range or are they all at the end
of the range?
Did you try Debra's suggestion of using a dynamic range? If so, what does
you formula look like?
Biff
|