Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
 
Posts: n/a
Default Pull unique names for drop down list

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?

  #3   Report Post  
 
Posts: n/a
Default

Debra - Thanks for the response. I don't think Autofilter would work
for this application. I didn't specify on my original post but the
original data with the multiple names is different than the data that I
would like to reference in a drop down list. The original list has a
name and a certain number. The number associated with the names places
that name in a predetermined position in a chart (multiple positions
when there are multiple names). I'd like the people to select their
name from the drop down, which would key Conditional Formatting to
highlight each spot in the chart where that name appears.
This list is only 50 names or so long so it would not be so hard to
manually remove the duplicate names for the drop down reference but I
have encountered this problem with much larger data sets with no
solution. I was hoping to figure something out on this small scale that
I could apply in the future on a larger scale.

  #4   Report Post  
Jason Morin
 
Posts: n/a
Default

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?

.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count Unique Names in list w/ Additional Criteria? Nodak Excel Worksheet Functions 1 January 26th 05 12:15 AM
Setting up a random list from long list of names ? yorkshire exile Excel Discussion (Misc queries) 4 January 6th 05 02:44 PM
Formula to list unique values JaneC Excel Worksheet Functions 4 December 10th 04 01:25 AM
How do I put a list of names and e-mail addresses in excel so tha. trav Excel Discussion (Misc queries) 4 December 2nd 04 03:56 AM
select unique to make list Spunky Excel Worksheet Functions 2 November 23rd 04 09:19 PM


All times are GMT +1. The time now is 06:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"