How to avoid blank rows in DATA VALIDATION list?

hi guys,
do you know how to prevent blank rows in data validation list?please help.
dvwihoutblankrows.xlsx

hi pejoi, your source for the validation should be from somewhere else consisting of this array formula:
=INDEX($A$3:$A$24,SMALL(IF($A$3:$A$24<>"",ROW($A$3:$A$24)-2),ROW(A1)))

you have to paste the formula inside the formula bar & press CTRL + SHIFT + ENTER

it looks in column A for those non-blanks & return you those text as you drag down the formula. hope that helps

Hi pejoi,

Simply make the data validation a list of numbers. You don't need a named range like your example. Look how I've done it. You can go up to 52 but I've stopped at 16.

Look in B31 where I've created a Validation List. Look at the Data Tab and Validation while on B31 to see the list.