Formula for Grouping

I

Ingus Smith

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need a Function for Grouping 2
Drop down menu questions 1
moving duplicate data in rows to columns with same name 2
lookup with multiple responses 2
Advanced Count functions 4
Reformatting a data table 4
Missing records on a CrossTab 1
Looking up with more than 1 criteria 5

Top