Validation List(No blanks)

C

Chris Morgan

I have a drop-down validation list within a particular
cell, allowing the user to make one choice from this list
for data input purposes.

The range that is allowed to be input is of a specified
length; however, the contents of this range constantly
changes, and will sometimes contain less entries then at
other times. This results in this range of cells sometimes
containing blank fields, which I would like to not appear
within the data validation drop-down list referencing this
range.

At present, such blank fields do appear in the drop-down
list (i have tried selecting 'do not include blank
entries', but to no avail)

Many thanks in advance,

Chris
 
J

Jason Morin

Suppose your dynamic list starts in A1 and goes down the
column. Use this under "Source" in Data Validation/List:

=OFFSET($A$1,,,COUNTA($A:$A))

HTH
Jason
Atlanta, GA
 
Top