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