Data Validation Ignore Blanks not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am using =INDIRECT(A1) in my data validation. "A1" is a Named Range on
another sheet (it is also the name of sheet, if that is significant). i do
this so that the contents of 'col2' corresponds to some value chosen in
'col1'. i have the named ranges set up correctly (i think), but there are a
ton of blank lines in my resulting list (the Named Range does indeed include
blank lines). i assumed that "Ignore Blanks" would take care of extraneous
blank values, but they still exist. am i doing something wrong?
 
If 'Ignore Blanks' is checked, you won't get an error message if a
referenced cell, or the cell with data validation, is blank.

However, it won't eliminate blanks from the source range for a dropdown
list.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ignoring Blanks in Data Validation 6
Indirect validation list with blank in list 3
Data Validation List with blanks 1
Data Validation - Ignore Blank 3
DATA Validation (Ignore Blanks) 3
Blanks Data Validation List 4
Data Validation 5
Excel Concatenate with line breaks but ignore blank cells 3

Back
Top