ExcelBanter - Numbering

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Numbering (https://www.excelbanter.com/excel-worksheet-functions/17949-numbering.html)

Lynne

Numbering

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" wrote:

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

Lynne

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

"Gary Brown" wrote in message
...
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" wrote:

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

All times are GMT +1. The time now is 07:13 PM.