How to combine list (range) and =NOT(ISBLANK(A1)) in datavalidation thanks
Belleke Well-Known Member Apr 11, 2021 #1 How to combine list (range) and =NOT(ISBLANK(A1)) in datavalidation thanks
P Peter Bartholomew Well-Known Member Apr 12, 2021 #2 Wouldn't that be achieved by simply unchecking the 'Ignore blank' box?
pecoflyer Well-Known Member Apr 13, 2021 #4 Which means those " blank cells " probably contain a null string ("") ?