ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Randomly Assign Tasks to employees in a month without repetitions (https://www.excelbanter.com/excel-worksheet-functions/454802-randomly-assign-tasks-employees-month-without-repetitions.html)

Mukayi Mutsago

Randomly Assign Tasks to employees in a month without repetitions
 
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.


All times are GMT +1. The time now is 07:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com