Count for duplicates

[SteveOranjin]

Hi there,

My formula is not returning what is should be returning. I've checked it over and I think it is good.

=SUMPRODUCT((COUNTIF('Data Sheet'!1:1,'Data Sheet'!1:1)-1)*('Data Sheet'!1:1<>""))>0

Can anyone tell me what is wrong with it?

 

[Special-K99]

"what is should be returning"

What should it be returning?

Just a simple count of duplicates as your subject title says or something else?