Validation List(No blanks)

  • Thread starter Thread starter Chris Morgan
  • Start date Start date
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
 
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
 
Back
Top