AutoNumber

[shimaa01234]

I need to special AutoNumber
Such as found in the column "A"

ID	NAME
1	A
1	A
1	A
2	B
3	C
1	A
4	D

<colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody>
</tbody>

 

[adam087]

How will you decide what number is needed?
If you need to fill in Col A or B based on the content in the other column, then will a VLookUp help?


/AJ

 

[NeonRedSharpie]

=CODE(B2)-64

I think?

 

[shimaa01234]

A wonderful solution and new
Thank you Mister "NeonRedSharpie"
Are there other ways to resolve

 

[NeonRedSharpie]

A wonderful solution and new
Thank you Mister "NeonRedSharpie"
Are there other ways to resolve

Is your sample data what your ACTUAL data looks like or are they real names?

 

[shimaa01234]

Of course the real names
If the column "B" contains numbers like that

ID	no
1	3433
1	3433
2	3433
3	5677
1	3433
4	3434
5	3435

<colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody>
</tbody>

 

[NeonRedSharpie]

I don't see the criteria for your numbering system. Why is 3433 both 1 and 2?

 

[shimaa01234]

Because numbering linked by repeating the number or name
If the number or name repeater takes the same numbering and if it is not normally numbering

 

[shimaa01234]

I have "asked" this request in "Excel form"
But is not reached to resolve I want
You can view it from this link
Duplicate serial number