Data Validation List with blanks

V

Vinod

Hi,

I've given a data validation with list, source as fixed name range ( include
blanks) and settings Ignore blanks is checked.

The issue I'm facing is Dropdown list displaying all the values from the
given named range including blanks.

Please help me out how to exclude blanks from dropdown list.

If possible:
Another scenario, some times I'm creating a named range dynamically using
'OFFSET' function by finding last used cell in named range required column
i.e., There are some blank cells included inbetween first cell and Last cell
after creation of dynamic named range.

In this scenario, how to excldue blanks if I give this named range as source
to one of the data validation.

Advanced Thanks,
~Vins
 
T

T. Valko

That's *not* what the ignore blank option is for.

The only way to not have the empty cells appear in your drop down is to not
have empty cells in the source list.
 

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

Data Validation 5
Data validation list using filtered range 3
Blanks Data Validation List 4
Validation list with non blanks from different column 3
Ignoring Blanks in Data Validation 3
Data validation, select from list: omit blanks? 1
Offset Named range in Datavalidation List 3
Data Validation with dynamic ranges 2

Top