Duplicate Values

[Declamatory]

Hello,

I have a list of names in column A.

In Cell D4 I want a message to appear if column A contains any duplicates.

What formula could I use?

Thanks.

 

[Bo_Ry]

Please try
=IF(OR(INDEX(COUNTIF(A1:A999,A1:A999)>1,)),"duplicate","")

 

[Declamatory]

Cheers. Appreciate the help.