Hi All
have been trying to solve this one myself with a lot of googling, looking on forums etc and can't quite find an answer.
I need to put together a rota for a small team operating audio-visual equipment. Some of the team are trained to operate the mixing desk plus microphones, some are only trained to operate microphones. So I have three lists of people and four slots to fill on each date: One person on the Desk, Roving Mic1, Roving Mic2, Rostrum mic adjustment.
So there are five headers on my sheet - DATE, DESK, ROVER1, ROVER2, ROSTRUM
Date is no problem got that set up to fill itself. I can fill the four columns with names from the sheet containing the columns of names, but what I need it to do is check for a duplicate name in the same row (so that one person is not assigned two jobs on the same day), then I want to check the next row for the next event date and ensure that the people used on the previous date are not used again (no problem if they're used on the next one after that).
I'd really like a reasonably easy formula that I can stick in a cell, will call a name from the source name list, then shunt it to the next name in the list and that I can populate the next row cells with that will check if their name was used in any of the cells in the previous row.
Hopefully that makes sense!
Thanks in advance
have been trying to solve this one myself with a lot of googling, looking on forums etc and can't quite find an answer.
I need to put together a rota for a small team operating audio-visual equipment. Some of the team are trained to operate the mixing desk plus microphones, some are only trained to operate microphones. So I have three lists of people and four slots to fill on each date: One person on the Desk, Roving Mic1, Roving Mic2, Rostrum mic adjustment.
So there are five headers on my sheet - DATE, DESK, ROVER1, ROVER2, ROSTRUM
Date is no problem got that set up to fill itself. I can fill the four columns with names from the sheet containing the columns of names, but what I need it to do is check for a duplicate name in the same row (so that one person is not assigned two jobs on the same day), then I want to check the next row for the next event date and ensure that the people used on the previous date are not used again (no problem if they're used on the next one after that).
I'd really like a reasonably easy formula that I can stick in a cell, will call a name from the source name list, then shunt it to the next name in the list and that I can populate the next row cells with that will check if their name was used in any of the cells in the previous row.
Hopefully that makes sense!
Thanks in advance