dynamic named range drop-down list to exclude N/A errors

Hello,

I have a dynamic named range which allows me to have an automatically growing drop down list in B1 as more cities are added in column A.
however, my workbook will have N/A errors to begin with before cities are added.

is there a way for my drop down list in B1 not to include the N/A errors and only the cities? of course when the next N/A error turns into a city, i would like the B1 drop down list to recognise this and include it.


thank you