Hi All,

I need to know a way where I can key in a data validation in cell.

I have a range A1: A45

I have names in it but with blanks in between them

I cannot delete the blanks as it is a business requirement. But the
validation which I have added to a group of cells which on click of
drop down should only get the names from A1:A45 and not display the
blanks in between as it looks awkward.

Questions:

Can this be done with the help of a single excel function
or there is any other way to do this via code.

Kind Regards,

Yuvraj