Managing Data

Hello!

I currently have a spreadsheet designed to programme the work of a team of people. Essentially it currently consists of the following column headers:

Auditor Job id Date of last audit Week Number Next Audit Week

Just a quick explanation, from the date Excel generates a Week number. It then adds the number of weeks between visits to this number and projects when the next visit is due.

The complication is that for every third visit another worker must complete the check to ensure the other one is doing their job properly. I would like the file to automatically say that once this site has been audited twice by Mr A, it indicates that Mr B must do the next one.

Am hoping that someone out there can figure this out as I can't! Am tempted to think I'm straying into data base territory.

Darren

Hello again.

Am not sure if I've not had any replies because it's not possible, or whether I've just not explained it that well. If anyone would like a different explanation please post a message and I'll do my best to make it clearer.

Thanks

Darren

Rob

Thank you for that. I'll try it today and let you know how I get on. It may be that something more complex will be needed, if so I will take you up on the offer and attach a sample file.

Just to confirm, it will always be 2 x Mr A, 1 x Mr B and so on.

Thanks a lot for your help.

Darren

Rob,

Thanks again for your help, and it is more complex than I thought! As suggested, I have attached a sample report with a little more explanation.

Thanks

Darren