Total instances of the same numbers from one column?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Back
Top