Go back to the beginning of a list after reaching the end
As can be seen in the attached worksheet Saff_roster.xlsx has a relationship with 207 workers. Let's assume that the next one to be cast is number 200, Mr. Omar Kaniosky, and we have to cast 20 workers. So the scale starts at the number 200, goes to the end of the list and goes back to the beginning of the list to complete the task.
What formula should I use in this case?
Thanks in advance
|