how to do a cumulative count?

[jbaich]

is there a formula to count the occurrences of a value one at a time? for example if the name john appears 3 times in a column of names, how can I get the adjacent cells in the next column to show 1 for the first occurrence, 2 for the second and 3 for the third?

Thanks so much,
Joe

[macropod]

You could use a COUNTIF formula, along the lines of:
=COUNTIF($A$1:A1,A1)
for data in column A, starting in A1 and copied down as far as needed.