Is grouping possible??

I am a teacher and beginner Excel user... but I would like to create an excel sheet that can be used to organize and group my students and then be exported into Powerpoint to display for students. I would like to be able to create separate lists of students who are incompatible with others, ones who work well together, ones who are in the same ability group, and finally other characteristics (bilingual, etc.) I would like to be able to input all the data and then be able to randomly (or select on some days) organize into groups of 5. Some days I would like to be able to group into two students. Is this possible and if so what formulas would I have to use?