show non NA() in drop menu

[bluepenink]

hello

im having trouble showing only NON --> #N/A

so basically here is my range

Joe
#N/A
#N/A
Fred
#N/A
#N/A

so how can in my drop down show only Joe and Fred?

Can someone pls help!

 

[Joe4]

It might be better to address the problems causing the #N/A error. If we can return a blank instead, we can filter out the blank records.

Are those the results of a formula?
What is the formula?