Formula for Grouping
 

I have a question. I am new to excel and I have been challenged with the task
of grouping students together who needs the same courses. Example: Billy
needs Math, Science, and English; Jane needs Math and English; Bob needs
Math, Science, and English; Eric needs only Science; Ashely needs Math and
English. How can I group 50+ students together that needs the same course,
and label the groups as Group A, Group B, Group C, etc., and what formula is
used, because I see too many combination but no solution.

Thank in advance...

Formula for Grouping
 

see response to your previous posting in another newsgroup

--
Regards
Roger Govier

"Ingus Smith" wrote in message
...
I have a question. I am new to excel and I have been challenged with the
task
of grouping students together who needs the same courses. Example: Billy
needs Math, Science, and English; Jane needs Math and English; Bob needs
Math, Science, and English; Eric needs only Science; Ashely needs Math and
English. How can I group 50+ students together that needs the same course,
and label the groups as Group A, Group B, Group C, etc., and what formula
is
used, because I see too many combination but no solution.

Thank in advance...