Numbering

L

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
 
G

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
 
Top