Feb 22 2022 09:39 AM
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