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

 

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