ROTAS - Excel 2003
 

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

ROTAS - Excel 2003
 

Using Excel's built-in Help, read up on the COUNTIF function.

Two ways it can be used a

- In an extra column(s) to report how many times a job is allocated.

- In conditional formatting to highlight jobs allocated too much (or
too little)

For a more specific suggestion, it'd help to know more about the data
layout.

ROTAS - Excel 2003
 

if your data that you need to check are in col A:

=IF(MAX(COUNTIF(INDIRECT("A2:A"&(MAX((A2:A1000<"" )*ROW(A2:A1000)))),INDIRECT("A2:A"&(MAX((A2:A1000< "")*ROW(A2:A1000))))))1,"Duplicates","No Duplicates")

--
Please click "yes" if this post helped you!

Greatly appreciated

Eva


"Linda" wrote:

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