how to sort people into groups based on their preference and category in excel?

%3CLINGO-SUB%20id%3D%22lingo-sub-3200166%22%20slang%3D%22en-US%22%3Ehow%20to%20sort%20people%20into%20groups%20based%20on%20their%20preference%20and%20category%20in%20excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3200166%22%20slang%3D%22en-US%22%3E%3CP%3EHey%2C%20i%20have%20no%20idea%20about%20excel%20at%20all.%20I%20just%20got%20an%20excel%20sheet%20of%20people%20interested%20in%20joining%20a%20workshop%20and%20they%20had%20to%20name%20at%20least%20one%20out%20of%205%20groups%20that%20they%20preferred%20working%20on.%20I%20am%20supposed%20to%20make%205%20roughly%20equally%20sized%20groups%20based%20on%20their%20group%20preference%20and%20the%20job%20categorizaion.%20i%20will%20have%20to%20categorize%20them%20into%20their%20job%20category%20based%20on%20the%20information%20that%20they%20provided%20before%20i%20can%20sort%20them.%20the%20groups%20should%20be%20quite%20balanced%20and%20not%20only%20have%20people%20from%20one%20area.%20does%20anyone%20have%20any%20tips%3F%20i%20hope%20there%20is%20some%20excel%20function%20that%20can%20make%20my%20life%20a%20little%20bit%20easier%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3200166%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hey, i have no idea about excel at all. I just got an excel sheet of people interested in joining a workshop and they had to name at least one out of 5 groups that they preferred working on. I am supposed to make 5 roughly equally sized groups based on their group preference and the job categorizaion. i will have to categorize them into their job category based on the information that they provided before i can sort them. the groups should be quite balanced and not only have people from one area. does anyone have any tips? i hope there is some excel function that can make my life a little bit easier

0 Replies