Distribute rows equally & roundup function mess

Hi guys,
I have digging around this one for a while now, let me explain. I am trying to split a list according to the amount of people available on this day. So in my sheet I have X number of rows and Z number of person. X/Z will give me the amount of rows by person, easy, it works fine (the final goal is to color each block of row for each people).

My issue is the following : Let say I have 24 rows and 10 people, the roundup function gives me 2 rows by person, and I get 10 times 2 row = 20 rows, how to distribute the last missing 4 rows ?
My idea would be to have 8 x 2rows + 2 x 4rows = 24 rows
I cannot figure out the mathematic way to handle this case.

i have included my code below (I define staff and TotalRows, and it colors the rows accordingly)

* All my datas are entered in Col A, from cell A5, that's why I have a firstrow=5

Please Login or Register  to view this content.

Thanks for your help !
Oli

can you attach a sample file with data and desired output ?

Hi, oli_g,

maybe have a look at this code:

Please Login or Register  to view this content.

Ciao,
Holger