Unique list for use with validation list

philobr

Active Member
Joined
Oct 17, 2005
Messages
280
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?
 
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?
 
Upvote 0

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
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?
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,224,828
Messages
6,181,215
Members
453,024
Latest member
Wingit77

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top