formula for a seating chart
 

Hello.

I have a class that has 4 rows of seating. 8 in rows 1-3 and 5 in row 4
for a total of 29.
I change the seating chart 8 times a year. My objective is that a
student only sit once in row 1 and row 4, and preferably all get to sit
in these rows.

Is there any way that I can set a formula to do this?

Thank you in advance.

M Zahedi

For ty the end of the 4th change, everyone will have sat in both the 1st row
and the 4th row. The 5th, 6th, 7th and 8th change, according to your wishes,
everyone must sit in rows 2 and 3. I don't think this will work unless you
put in extra seats.
Gary Brown


"M Zahedi" wrote:

Hello.

I have a class that has 4 rows of seating. 8 in rows 1-3 and 5 in row 4
for a total of 29.
I change the seating chart 8 times a year. My objective is that a
student only sit once in row 1 and row 4, and preferably all get to sit
in these rows.

Is there any way that I can set a formula to do this?

Thank you in advance.

M Zahedi