Formula to create a list based

[Dazzybeeguy]

Hi - If I have a list of 365 Days and there are 3 shifts per day, I want to create a list where each person appears in that list for the number of shifts in the adjacent column, is there an excel formula way to achieve this.

So in the table shown Person 1 needs to be allocated 83 shifts out of the 869, person 2 = 74 etc

Thanks

Person	Shifts
Person 1	83
Person 2	74
Person 3	41
Person 4	50
Person 5	41
Person 6	58
Person 7	74
Person 8	50
Person 9	50
Person 10	50
Person 11	83
Person 12	50
Person 13	58
Person 14	66
Person 15	41

 

[bebo021999]

There must be a source data somewhere.
Could you attach it?

 

[myall_blues]

Also what are the rules about shift allocation? Presumably you don't want someone to do 83 shifts back to back and have the rest of the year off, for example?