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 dont know whether this is the exact method is used for this, just I have
given my suggestion€¦

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"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.