Unique values in data validation

Hi all,

is it possible to show unique values in data validation list.

Thanks in advance

you can put pretty much anything in a data validation list, as long as you can give the list the info needed..which means you would have to find the unique values, and somehow reference them for the DV list..

Hope that helps

I'm trying to help you, but you are not really giving me any information to work on here, WHAT do you actually want to appear in the data validation list? unique values, or just 1 of every value?..if whats in the list on your sample is what you want, then what is the question?...it seems you may have solved your own question

@dredwolf,

OP is offline now...

@ sixthsense
thanks, and I am still not sure what they want...

@dredwolf,

Your post #2 and post #3 is the OP's expected result, but unfortunately OP just posted the question and gone away...

@sixthsense
oh well, I seem to get a lot of those...lol

Well, I hope you at least figured out your issue, thats what we are here trying to do, and from the sample you uploaded, it looks like you did, without our help, so good for you !