Hi,
We will be giving daily call list to 7 agents, and we need to divvy the calls equal. I have attached an example spreadsheet.
On the attached example we would need to populate col D. In this example each agent would need 12.14 calls if rounding is a problem I don’t mind if one person gets a call more or has a call less. The formula to work out the number of calls is in cell L1. Is it possible to build a formula which will show each agent 12 times. The 12 calls would vary day to day.
I hope I explained it properly if not please let me know.
Thanks
Bookmarks