Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
extracting names | Excel Discussion (Misc queries) | |||
One list unsorted, but two groups - I need to rank in each group | Excel Discussion (Misc queries) | |||
Percentage calculations from an unsorted two column list | Excel Discussion (Misc queries) | |||
lookup unsorted list | Excel Discussion (Misc queries) | |||
An unsorted list in vlookup | Excel Worksheet Functions |