Use datafilteradvanced filter to get a unique listname it use the name
=mylist

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"shepster" wrote in message
...
I have created a dropdown in excel 2007. This drop down contains a list of
data with many repeats, ie

A
A
A
B
B
C
D
D

How can I have a list only show a data point ONCE so it would look like...

A
B
C
D

This is important as I created drop downs dependant on other drop downs --
cleaning up these lists will improve the usability of the workbook.
Thanks!