# Auto Number +1 from text, if duplicate text not increase

• Hi All,

Can help me about formula in column B want result generate Number +1 from column A if Name same / duplicate not increase number.
[TABLE="class: grid, width: 500"]

[tr]

[td]

Name

[/td]

[td]

Number (Result)

[/td]

[/tr]

[tr]

[td]

a

[/td]

[td]

1

[/td]

[/tr]

[tr]

[td]

a

[/td]

[td]

1

[/td]

[/tr]

[tr]

[td]

a

[/td]

[td]

1

[/td]

[/tr]

[tr]

[td]

b

[/td]

[td]

2

[/td]

[/tr]

[tr]

[td]

c

[/td]

[td]

3

[/td]

[/tr]

[tr]

[td]

d

[/td]

[td]

4

[/td]

[/tr]

[tr]

[td]

d

[/td]

[td]

4

[/td]

[/tr]

[tr]

[td]

e

[/td]

[td]

5

[/td]

[/tr]

[tr]

[td]

f

[/td]

[td]

6

[/td]

[/tr]

[tr]

[td]

g

[/td]

[td]

7

[/td]

[/tr]

[/TABLE]

Thanks - John

• Re: Auto Number +1 from text, if duplicate text not increase

Type the first result into B1 (1), then in B2 copied down:

=IF(COUNTIF(\$A\$1:A2,A2)>1,B1,B1+1)

Ali

Enthusiastic self-taught user of MS Excel who's always learning!
If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

• Re: Auto Number +1 from text, if duplicate text not increase

Quote from AliGW;774431

Type the first result into B1 (1), then in B2 copied down:

=IF(COUNTIF(\$A\$1:A2,A2)>1,B1,B1+1)

Thanks ALiGW it's work great.

• Re: Auto Number +1 from text, if duplicate text not increase

You're welcome!

Ali

Enthusiastic self-taught user of MS Excel who's always learning!
If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!