Numbering

[Lynne]

Hi,
I need to serially number occurrences of a name in a column. Would
appreciate urgent assistance.

eg
1 Anna
1 John
2 Anna
1 Chris
3 Anna
2 John

Lyn

 

[Gary Brown]

Assuming the list starts in A1 with 'Anna', put this formula in B1 and copy
down.
=COUNTIF($A$1:A1,A1)

HTH,
Gary Brown

 

[Lynne]

Thanks a ton for your quick reply ..was giving the range incorrectly. Lynne