ROTAS - Excel 2003

[Linda]

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

 

[zvkmpw]

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

Two ways it can be used are:

- 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.

 

[Eva]

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