Rosters
I have a a crew of 12 which I have to write a roster for on a weekly basis.
Each day I have 8 tasks which I have to assign someone to. Is there a way to calculate how many times each person has been assigned a particular task on a weekly/re-ocurring basis? I don't use excel at all but would appreciate any assistance as counting all the cells manually takes a bit of time, especially when the rosters change. many thanks |
Rosters
I will send you an email of a simple roster with a summary sheet to look at.
Mike F "GraffixNZ" wrote in message ... I have a a crew of 12 which I have to write a roster for on a weekly basis. Each day I have 8 tasks which I have to assign someone to. Is there a way to calculate how many times each person has been assigned a particular task on a weekly/re-ocurring basis? I don't use excel at all but would appreciate any assistance as counting all the cells manually takes a bit of time, especially when the rosters change. many thanks |
Rosters
Guess I'll need your real email address. You can disguise it by adding a
word to it that obviously isn't part of your address to keep from getting spammed in the future like: Mike F "Mike Fogleman" wrote in message m... I will send you an email of a simple roster with a summary sheet to look at. Mike F "GraffixNZ" wrote in message ... I have a a crew of 12 which I have to write a roster for on a weekly basis. Each day I have 8 tasks which I have to assign someone to. Is there a way to calculate how many times each person has been assigned a particular task on a weekly/re-ocurring basis? I don't use excel at all but would appreciate any assistance as counting all the cells manually takes a bit of time, especially when the rosters change. many thanks |
All times are GMT +1. The time now is 04:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com