=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