Formula to Dta Drop down

[Rkeev]

Good Day all,

I'm trying to convert a formula into a data validation dropdown, but I am having little success.
The code works fine if I drag it down, but I want it in a validation list due to space restraints.

I've tried making it a named formula but I can't get it to "LIST" all the names and when I try to remove the small function I get incorrect results.

Any help would be appreciated

{=IF(ROWS(K$61:K61)>K$60,"",INDEX($A$4:$A$9,SMALL(IF(D$4:D$9="",ROW(D$4:D$9)-ROW(D$4)+1),ROWS(K$61:K61))))}

Rkeev