Calc duplicates
 

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.

Calc duplicates
 

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.

Calc duplicates
 

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.

Calc duplicates
 

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.