Hello everyone,

I have some values from B1:J1, but in some cells in B1:J1 are empty.

It is possible get a Formula to get a dropdown list using Data Validation that shows only cells that are not empty?

I've been trying with 
Please Login or Register  to view this content.
Thanks in advance for any suggestion.