Unique dropdown list from column data

[sparky2205]

I want to create a dropdown list from a column of data that contains duplicates and blanks.
The dropdown list should contain 1 of each data entry with no blanks.

Sample data:
ESI

GL

ESI
ESI

AZ

ESI

ESI
ESI

SO

EG

I have tried =INDEX(Supervisors,MATCH(0,COUNTIF($E$3:E3,Supervisors),0)) with the above column being named Supervisors. But it doesn't work. Maybe due to the blanks?

Note: the data above is padded out to 10 chars with spaces. It comes from another system in that format.

 

[sparky2205]

Yes, works perfectly again.
Now I have a bit of homework to understand exactly what is happening with those formulas.

As usual, thanks very much for your time and another successful outcome. Have a nice evening.

 

[Fluff]

You're welcome & thanks for the feedback.