I think you'll probably find some help for your situation over at:
http://www.contextures.com/tiptech.html
Look down in the 'D' section for various tips dealing with Data Validation.

"Ayo" wrote:

I am trying to see if this is possible. I know it is possible in Access but
I'm not
sure if it is in Excel. I have a few coulmns with repeated values and I want
to
find a way to get the unique values from these coulmns and use them as the
values in a combobox list. So there are two steps to this, first is defining
what the unique values are and then using those values in a dropdown control.
Thanks for the help.