LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 12
Default Extracting names from an unsorted list.

I have the following data table.

Name Month qs1 qs2 qs3
John Jan-07 4 5 5
John Jan-07 4 4 3
Jim Jan-07 5 5 5
Jim Jan-07 4 4 5
John Feb-07 5 5 4
John Feb-07 5 4 5
Alice Feb-07 5 5 5
Alice Feb-07 4 4 5
Jim Feb-07 5 3 3
Jim Feb-07 5 5 5

What I am trying to do is extract a list of the names. the names are in a
dynamic range call namelist. As time goes on names could be added to the
list and I would like to have an automatic list of all names for use in a
drop down list for score review.

Thoughts and Thanks!


 
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
extracting names CJ Excel Discussion (Misc queries) 10 January 11th 07 05:28 AM
One list unsorted, but two groups - I need to rank in each group Skiffie Excel Discussion (Misc queries) 0 August 21st 06 08:10 AM
Percentage calculations from an unsorted two column list Rokuro kubi Excel Discussion (Misc queries) 3 July 15th 06 02:27 AM
lookup unsorted list sslenterprises Excel Discussion (Misc queries) 2 October 25th 05 09:24 AM
An unsorted list in vlookup Traima Excel Worksheet Functions 2 August 8th 05 01:10 PM


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

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

About Us

"It's about Microsoft Excel"