Index formula to pull unique names only from a column

[Fawkes_]

I think I may just be over thinking this, but im to the point where id rather ask instead fo assume.

I was playing with the define names in the formula tab to preload combo boxes (have that part figured out)

But I was running into issues with figuring out how to get defines names to show unique values only.

I was trying to use and index but im just messing it up... any ideas from the wiser forum users?

Attached a spread sheet with a name list similar to what im trying to adjust.