Thread: Extracting names from an unsorted list.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Extracting names from an unsorted list.
Excel has a feature just for this kind of application - Autofilter

Just click on A1 and pull-down
Data Filter AutoFilter

also see:

http://www.contextures.com/xlautofilter01.html




--
Gary's Student
gsnu200708


"Brian H" wrote:

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!



Reply With QuoteReply With Quote