Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Does anyone know where to start to set up the below:
I have a list of about 5 tasks that need to be done. (5 now, but may vary later) I have 10 people to carry out the tasks. (10 now but may vary up/down later) I want each task to be done by someone each time, but rotate them so all get a task. But I would like to set maybe a level system. EG. Level 1 Able to do tasks 1,2 Level 2 Able to do tasks 1,2,3 Level 3 Able to do tasks 1,2,3,4,5. Example: man 1 - man 10 Task 1 Task 2 Task 3 Task 4 Task 5 man 1 man 2 man 3 man 4 man 5 Task 1 Task 2 Task 3 Task 4 Task 5 man 10 man 8 man 6 man 7 man 5 But keeping in mind that say for instance 'man 1-5' can do ALL 5 Tasks, But 'man6 and 7' can only do Task 1,2, and 'man 8,9,10' can only do Task 1,2,3. How would I approach this one??? It has baffled me for a while... Corey.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Setting Conditional Formatting | Excel Worksheet Functions | |||
Conditional Format Not Working | Excel Discussion (Misc queries) | |||
Conditional formula - language needed | Excel Worksheet Functions | |||
Are conditional formats available for setting page breaks? | Excel Discussion (Misc queries) | |||
Need help with conditional rates and roster times for payroll | Excel Discussion (Misc queries) |