Duplicates formula
 

Result
Example

Result in col B
A B

100
100
100 3
200
300
300 2

Hi

I'd like to find the number duplicates in Column A, and place a result in
column B as shown on above in Col B. How do you create formulas?

Thanks
Soth

Duplicates formula
 

Soth wrote:
Result
Example

Result in col B
A B

100
100
100 3
200
300
300 2

Hi

I'd like to find the number duplicates in Column A, and place a result in
column B as shown on above in Col B. How do you create formulas?

Thanks
Soth



Assuming your data is in A1:A6, this array formula (commit with
CTRL+SHIFT+ENTER) will give you exactly those results:

=IF(ROW()=MAX(IF($A$1:$A$6=A1,ROW($A$1:$A$6),"")),
IF(COUNTIF($A$1:$A$6,A1)1,COUNTIF($A$1:$A$6,A1)," "),"")

Duplicates formula
 

=IF(OR(COUNTIF($A$1:A1,A1)=1,A1=A2),"",COUNTIF($A$ 1:A1,A1))


"Soth" wrote:


Result
Example

Result in col B
A B

100
100
100 3
200
300
300 2

Hi

I'd like to find the number duplicates in Column A, and place a result in
column B as shown on above in Col B. How do you create formulas?

Thanks
Soth

Duplicates formula
 

In B1:
=REPT(COUNTIF($A$1:A1,A1),A1<A2)
Copy down ...

Regards,
Bernd

Duplicates formula
 

You're the best Bernd !! Many thanks.

"Bernd P" wrote:

In B1:
=REPT(COUNTIF($A$1:A1,A1),A1<A2)
Copy down ...

Regards,
Bernd
.

Duplicates formula
 

Hi,

=if(or(A1=A2,countif(A$1:A1,A1)=1),"",countif(A$1: A1,A1))

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"Soth" wrote in message
...

Result
Example

Result in col B
A B

100
100
100 3
200
300
300 2

Hi

I'd like to find the number duplicates in Column A, and place a result in
column B as shown on above in Col B. How do you create formulas?

Thanks
Soth