Total instances of the same numbers from one column?

[Guest]

How do I total the number of occurances of one number from a column? I would
like to return the total in a seperate column at the first occurance of each
new number. If the list contains 8 cells with the number 12345, I would like
that total, 8, to be referenced in the next column at the first occurance of
the number and so on.
Suggestions?

 

[Guest]

If your data is in column A (starting A1) then in B1 (and copy down)

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

HTH

 

[PCLIVE]

One way,

=IF(MATCH(A1,A:A,0)=ROW(),COUNTIF(A:A,A1),"")

HTH,
Paul