This will count duplicates for you:
=SUMPRODUCT((A2:A78<"")/COUNTIF(A2:A78,A2:A78&"")*(A2:A78<""))
(starts counting in row 2; assumes title or label is in row 1)


=COUNT(1/FREQUENCY(A1:A400,A1:A400))
(does same as function above)


=SUM(IF(A2:A400<"",1/COUNTIF(A2:A400,A2:A400)))
(does same as function above; must be entered with Ctrl+Shift+Enter...not
just enter)



Regards,
Ryan---

--
RyGuy


"Derek" wrote:

Hi experts

I need to look down column Q, R, S and T and find duplicate values for the
same month and in a new cell just put a number of times they are duplicated
on the same row

ill explain, i.e.

Q R S T
Part 1 Part 2 Part3 Part 4
30.00 30.00 0.00 0.00

So in rows Q - T 30.00 appers twice, so id like cell U e.g. to report the
number 2

I hope that makes sense

Thanks

Derek