Who's up for a challenge? I am sure someone is smart enough to figure
this out. I have a way of doing it, but I am sure there is an easier
way.

Bottom line up-front. I need to separate students so that there are
roughly equal numbers of students over 1-5 periods. The reason I say
"roughly" is because there is a catch. The number of students
per-period needs to be an even number of students when possible. For
example:

16 students, 4 periods...the desired result would be 4 students in each
of the 4 periods. That's simple, but...

If there were 52 students, the result could not be 13 students in each
of the 4 periods, since they should be even numbers when possible. It
would be 14,12,14,12 or similar. (12,14,14,12, etc.)

At the time this process takes place, the TOTAL number of students per
class is already in one column...say Column A. The number of periods
(from 1-5) is also known at this point. Let's say this number is in
column B.

In columns C,D,E,F,G (representing periods) would be filled with the
student numbers (or a zero if none are in the period).

The student numbers can be anywhere from 2-60, but I'd think a solution
would work with any number of students.

If anyone finds a solution for this, you are indeed worthy of my
praise! :)


--
kevindmorgan
------------------------------------------------------------------------
kevindmorgan's Profile: http://www.excelforum.com/member.php...o&userid=32232
View this thread: http://www.excelforum.com/showthread...hreadid=533452