Unique list for use with validation list

[philobr]

How can I get a validation list to display a unique list of items?

My list contains multiple instances of the same entries Im trying to get a validation list to display the unique values so:

Item1
Item1
Item2
Item2
Item2
Item3
Item3

will display in the validation list as

Item1
Item2
Item3

I can then use this to populate a second validation list.

Any ideas?

 

[Zorod]

Perfect Aladin, thank you.

I'm looking for another solution. After filtering column A, I look at the filtered items to choose from in column B but they are unorganized. My data needs to be sorted alphabetically (smallest number first). Can this be accomplished?

 

[Aladin Akyurek]

Perfect Aladin, thank you.

I'm looking for another solution. After filtering column A, I look at the filtered items to choose from in column B but they are unorganized. My data needs to be sorted alphabetically (smallest number first). Can this be accomplished?

Don't follow. Must I conclude that I did is not what you asked for?

 

[Zorod]

Don't follow. Must I conclude that I did is not what you asked for?

Your previous solution was exactly what I needed but now I'm finding my data should be sorted alphabetically. In using the example here, can the List be generated alphabetically in this order: Joe, Moe, philobr, Sioux ? In other words can the Return Unique Items list be alphabetical (A to Z)? So when I go to my drop down validation list it will display alphabetically.

 

[kssaran2]

Mr. mgirvin
Thank you for your post to get "Unique List for use with validation list"
I've tried your formula in my spreadsheet, where I want to have unique list of numeric values (whereas you example has alphabets) with your formula i got the answer as #N/A

Please can you help me on this case

Saran

 

[Aladin Akyurek]

@kssaran2

Care to post a small sample along with the expected list?