Oops

A8 should be
=COUNTA(A1:A7)-SUMPRODUCT((A1:A7<"")/COUNTIF(A1:A7,A1:A7&""))


If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Check your previous post

--In cell A8
=MAX(FREQUENCY(A1:A7,A1:A7))

--In cell A9
=SUMPRODUCT((A1:A7<"")/COUNTIF(A1:A7,A1:A7&""))

Incase your data do not have any blank entries you can try the below formula
=SUMPRODUCT(1/COUNTIF(A1:A7,A1:A7))

If this post helps click Yes
---------------
Jacob Skaria


"backmara" wrote:

Hi,
I need function to calculating duplicates, how I create this?
A1: 1
A2: 2
A3: 2
A4: 3
A5: 3
A6: 3
A7: 4
A8: 5

Example answers:
Duplicates value A9: 3
unique values A10: 5

This is same functions that tool remove duplicats, but i haveto do this
automatically.