Trying to place students into groups w/ equal distribution of race/gender/etc

I have a an excel worksheet with 500+ students with a variety of fields, the important ones being Student Name, Race, Gender, and Grade. I need to create approximately 20 groups of 25-27 people that are comprised of a somewhat even representation of Race, Gender, and Grade Level.

Is there an automated way to do this through excel?

Would appreciate the help as situations like this are common throughout the year and if I could figure this out it would make my life so much easier!

Thanks for any help!

You can create Pivot Table with drop down menu that would filter out any of those criteria you've mentioned.

Would that be ok?