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