View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default 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...