Auto numbering for different names

**leeaw** · 03-24-2009, 01:11 AM

hi all i need help on this.

eg: i have to insert numbers in column a and the names in column b.

wht i require is :

andrew 1
andrew 2
chris 1
chris 2
daniel 1
daniel 2
daniel 3

anyone can help?

**vikas.bhandari** · 03-24-2009, 02:58 AM

Originally Posted by leeaw

hi all i need help on this.

eg: i have to insert numbers in column a and the names in column b.

wht i require is :

andrew 1
andrew 2
chris 1
chris 2
daniel 1
daniel 2
daniel 3

anyone can help?

Your clarification is not much of help. Can you please explain what exactly you are looking for?

Thanks!
Vikas Bhandari

**DonkeyOte** · 03-24-2009, 04:03 AM

If we assume names are listed in ascending order as indicated, first ensure first name appears in row 2, let's assume names are in A2 onwards (your example does not correspond to your narrative)

B2: =IF(A2<>A1,1,B1+1)
copied down

Without inserting a row before first name (if first name must be in 1) you would use COUNTIF but this could get expensive depending on how many names you have listed...

B1: =COUNTIF($A$1:$A1,$A1)
copied down

I would opt for the former approach.