Andy,

Try this formula

=IF(COUNTA(A1:A1000)=SUMPRODUCT((A1:A1000<"")/COUNTIF(A1:A1000,A1:A1000&"")),"No duplicates","Duplicates")

If you want to see the duplicates, add this formula to B1 and copy down
=IF(COUNTIF($A$1:$A$1000,A1)1,"Duplicate here","")
or wrap this formula;a in conditional formatting to colour the offending cell(so)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Andy Daugherty" wrote in message ...
Is there a formula to let me know if a duplicate item has been entered in a column?

Thanks
Andy