Total instances of the same numbers from one column?
 

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

Total instances of the same numbers from one column?
 

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

Total instances of the same numbers from one column?
 

One way,

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

HTH,
Paul

"Aimcorep" wrote in message
...
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