Hi,

I am uing data validation on cell A1 and choosing to allow from a list.
In the source box, I am clicking on column L (source =$L:$L). I have
selected the 'ignore blank' checkbox.

column L has 13 names. If there is something in columns A, B, C....etc in
rows 14 or greater then the dropdown list in cell A1 shows blanks along with
the names from column L.

does anyone know how I stop this happening?

Thanks for any help you cangive