number times a value appears in a column beside it chronological

  • Thread starter Thread starter Papa Cricket
  • Start date Start date
P

Papa Cricket

I am looking to count how many times a number appears in a column beside that
number as you go down that column. Beside the first occurance of the number
10 the cell in the column beside it would have a 1, the next occurance of the
number 10 the cell in the column beside it would have a 2, and so on. Thank
you in advance for your help.
 
Assuming the column of numbers begins in A1
In B1 enter =COUNTIF(A1:$A$1,A1)
Copy this down the column by double clicking B1's fill handle
best wishes
 
Sounds like a COUNTIF function, where the top of the range is fixed and the
bottom of the range is the current row. So if your data is in column A and
your count in column B, you could enter =countif(a$2:a2,a2) in cell b2, and
copy that down.
 
Back
Top