Need a Function for Grouping

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

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

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

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