Formula To Check for Duplicates excluding 0 and empty cells

[APML]

Hi all, I have a range C2:C51. I would like a formula that tells me if there are any duplicates excluding empty cells or 0.
Note cells C2 to C51 have the following formula in them
C2=Watch!$B$11
C3=Watch!B38
ect
So I'm wanting to check the outcomes of the formulas.

 

[Fluff]

Glad we could help & thanks for the feedback.

Also in future when marking a post as the solution please mark the post that helped, not your post saying it worked. Thanks

 

[APML]

Glad we could help & thanks for the feedback.

Also in future when marking a post as the solution please mark the post that helped, not your post saying it worked. Thanks

Sorry, will do (long day here, now bedtime for me), again thx for the help.