Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need a Function for Grouping
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need a Function for Grouping
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... |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need a Function for Grouping
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To sum by grouping | Excel Discussion (Misc queries) | |||
Locking cells but keeping Grouping Function available | Excel Worksheet Functions | |||
Function for grouping range of data | Excel Worksheet Functions | |||
Am I able to protect my work sheet and keep my grouping function? | Excel Worksheet Functions | |||
Grouping | Excel Worksheet Functions |