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