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.




"Roger Govier" wrote:

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 tabTableTable toolsSummarize with
Pivot Table
On the PT Skeletondrag Course to Row Labels followed by dragging Name to
Row labels

--
Regards
Roger Govier

"Ingus Smith" <Ingus wrote in message
...
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...