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

"Aimcorep" wrote:

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?
--
Aimcorep