Ingus Smith;219998 Wrote:
I have a question. I am new to Excel and I have been challenged with a
task
of grouping students that need the same course in Excel 2007 by my
employer.
Example: Billy needs Math, Science, and English; Jill needs Math and
English;
Eric needs only Science; Jane needs Math, Science, and English; Adam
needs
Math and English. How would I group 50+ students that need the same
course,
and what type of formula do I use? I need them to group like: Group A,
Group
B, Group C, etc...

Hi, a possible solution would be to use a Pivot Table grouping students
by course.
I can't guide you through it here not being proficient enough in 2007
and using 2003 for the moment.


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=60505