Randomly Assign Tasks to employees in a month without repetitions
From Mukayi Mutsago@21:1/5 to All on Fri Jun 19 08:51:37 2020
I have a total of 41 employees that I want to assign audits during work days (Mon-Friday). I have a total of 49 audit. The number of audits may change, but not frequently. I have one column with employee names and another with the audit tasks. For easier
reading of the schedule I will have days/Dates (Mon-Friday) in one column and I will have the employees as headers in the top row. The assignments will be picked and assigned under each employee's name. Each employee should perform and audit once per
month. The following month an employee will perform a different audit than the one from the previous month. Want to find out if there is a way to execute this in Excel.