Numbering

  • Thread starter Thread starter Lynne
  • Start date Start date
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
 
Assuming the list starts in A1 with 'Anna', put this formula in B1 and copy
down.
=COUNTIF($A$1:A1,A1)

HTH,
Gary Brown
 
Thanks a ton for your quick reply ..was giving the range incorrectly. Lynne
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Differences between columns 3
calculate ranking 2
merged data into one 7
Create New Table/Column 1
This is not a question about C# but a simple question about SQL query 6
Odd results from Crosstab w/ Date/Time field 1
Help 1
combining tables into query 2

Back
Top