I have job rotas on 3 worksheets - 1 with people allocated to jobs (with
dates) on one and jobs info on the other 2. Please could you advise if there
is a formula I can enter to check duplication - that I haven't allocated the
same job for the same period twice - or vice versa? I don't know very little
about doing things like this and have done some checks just by looking down
filter columns. Thanks