Thread: [Solved] Arranging Into Groups
View Single Post
Old 09-06-2011, 10:23 PM
skoz55 skoz55 is offline Windows 7 64bit Office 2010 64bit
Join Date: Jan 2009
Posts: 20
skoz55 is on a distinguished road
Default Arranging Into Groups

I have a spreadsheet with 48 different students with they're grades ranging from 10 - 0. I would like to place the students in 8 groups with a top scorer in each, second top scorer in each, third...

So the groups will consist of the following students in each
Group #1 - 1,7,13,19,25,31,37
Group #2 - 2,8,14,20,26,32,38
Group #3 - 3,9,15,21,27,33,39

I have to do this with 24 spreadsheets of students, thus hoping there is a method that Excel can automate this task.

Thanks for any help.
Reply With Quote