Calc duplicates

[backmara]

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.

 

[Jacob Skaria]

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]

Oops

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


If this post helps click Yes

 

[Ms-Exl-Learner]

Try this…

In B1 cell apply the below formula

=IF(COUNTIF($A$1:$A$8,A1)>1,"",1)

Now copy the B1 cell and paste it upto B8.

In A9 Use this formula

=SUM(B1:B8)

OR

=COUNT(B1:B8)

In A10 use this formula

=COUNT(A1:A8)-SUM(B1:B8)

OR

=COUNT(A1:A8)-COUNT(B1:B8)

I don’t know whether this is the exact method is used for this, just I have
given my suggestion…

If this post helps, Click Yes!