Hi Experts
A bit of background
We are a team of 14 people and there are a few tasks that all of us hate to do i.e. gluing, tapping & potting
WHat we have decided is we all will take turns doing it so everybody does it

Problem
Not all days have these tasks and some days there are just a few and someday a lot

Solution Tried
Given each person a day, so they do what ever tasks need to be done
Problem
Some guys end up doing a lot because unluckily for them the day they have keeps getting the most tasks

Help and Ideas
What i would please like is a solution or point me towards a solution in Excel

How can i setup these tasks, which will record who did how many of these tasks on what day and make a recommendation of who needs to do the next tasks

Could have the names of all the employees
The list of tasks
Job number and quantity can be entered and who did the tasks
Based on todays task list, a formula to recommend who should be assigned tasks the next day

The formula needs to be fair to the people so the workload is shared equally

Thanks
Regards
Rahul