With names in A1:A50, put this in B1, press
ctrl/shift/enter, and fill down to row 50:
=INDEX($A$1:$A$50,SMALL(IF(ROW($A$1:$A$50)=MATCH
($A$1:$A$50,$A$1:$A$50,0),ROW($A$1:$A$50)),ROW()))
You can now create your drop-down list (say in C1).
Select C1, go to Data Validation, choose "List"
under "Allow:" and under "Source:" put:
=OFFSET(B1,,,COUNTIF(B:B,"*"))
HTH
Jason
Atlanta, GA
-----Original Message-----
I have a list of about 50 people's names associated with
data. Some of
the names are repeated up to five times. I'd like to
creat a drop down
list so that a person can pick their name from the drop
down list and
their data will be highlighted. The problems is that I
would like to
take my large data list and somehow convert it into a
down list with
having all the repeated names, just list one name per
instance. Is
there a convenient way to do this?
.
|