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

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),""),"")

=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
>

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

Regards,
Bernd

You're the best Bernd !! Many thanks.

"Bernd P" wrote:

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

Hi,

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"Soth" <(E-Mail Removed)> wrote in message
news:71AD4304-84EC-4D54-93FC-(E-Mail Removed)...
>
> 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
>