number times a value appears in a column beside it chronological
 

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.

number times a value appears in a column beside it chronological
 

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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

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

number times a value appears in a column beside it chronological
 

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.

"Papa Cricket" wrote:

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.

number times a value appears in a column beside it chronological
 

Senior moment!
That should read =COUNTIF($A$1:A1,A1)
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

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