| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I protect cell numbering format ($) but allow editing? | Excel Discussion (Misc queries) | |||
| Auto page numbering for several worksheets | Excel Worksheet Functions | |||
| Numbering pages | Excel Worksheet Functions | |||
| excel numbering add-in | Excel Discussion (Misc queries) | |||
| Page Numbering | Excel Discussion (Misc queries) | |||
Hybrid Mode
