Forum Discussion
Creating a running name list
shanam1580 Perhaps someone else here can come up with a mathematical approach. I couldn't so I went for a good old manual one. With some logic, I worked out a consistent schedule for 39 children allocated to your 6 nurses. That list of 39 can be repeated over-and-over again.
See attached in the yellow shaded area. Just fill in the real names in the green area. Would that work?
Thank you so much for a good extensive and pedagogic answer. I've had issues with the formula that creates the running list though =IF(ROW() <= SUM($C$2:$C2), D2, "")
Im not sure if its because ive had to translate to Swedish but the computer wont accept it. Do you have any othe suggestions regarding how to fix that?
I followed the instructions by the letter and came up with nonsense as shown in the attached file.
smylbugti222gmailcom , can you please explain your instructions and demonstrate how this should work. With 35+ years Excel experience, I can't get it to work.
- Thats exactly how it turned out for me too.
shanam1580 And I guess that was not what you had in mind. Can you elaborate a bit more about what you mean by "to take the next listing at our clinic".
- Basically
Who's turn it is to take on a new listing at the clinic. Does that make any sense?
If X works 100% and Y 50%, X's name apears 2 times as often on the list compared to Y. so we get the same amout of workload based on how much we wok (we run a healthcare clinic for kids 0-5 so listings are usually newborns that follow a set programme until 5 years )