number times a value appears in a column beside it chronological

[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.

 

[Bernard Liengme]

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

 

[bapeltzer]

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.

 

[Bernard Liengme]

Senior moment!
That should read =COUNTIF($A$1:A1,A1)