Need a Function for Grouping

[Ingus Smith]

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...

 

[Pecoflyer]

I have a question. I am new to Excel and I have been challenged with
task
of grouping students that need the same course in Excel 2007 by m
employer.
Example: Billy needs Math, Science, and English; Jill needs Math an
English;
Eric needs only Science; Jane needs Math, Science, and English; Ada
needs
Math and English. How would I group 50+ students that need the sam
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 student
by course.
I can't guide you through it here not being proficient enough in 200
and using 2003 for the moment

--
Pecoflye

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

*Adding your XL version* to your post helps finding solution faste

 

[Roger Govier]

Hi Ingus

I would enter all the data into 2 columns
Name Course
Billy Math
Billy Science
Billy English
Jill Math
etc.

Then place cursor in cell A1 >Insert tab>Table>Table tools>Summarize with
Pivot Table
On the PT Skeleton>drag Course to Row Labels followed by dragging Name to
Row labels

 

[Ingus Smith]

sorry for not showing what it should look like. The spreadsheet will look
like this.
StuName Math Science English
Billy 1 1 1
Jill 1 1
Jane 1 1 1
Adam 1 1
Eric 1
And I need to group the students and have it show up like this:
GroupID Math Science English
Group A 1 1 1
Billy
Jane
Group B 1 1
Jill
Adam
Group C 1
Eric
So if you would be able to expand the groups and see the students within
that group...
Thanks again for the help.