Need a Function for Grouping

  • Thread starter Thread starter Ingus Smith
  • Start date Start date
I

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