Hello,
i want to generate a sequential number pressing a number
example
A B
1 AA 99
2 AA990001
3
imagine i press a buttom and it will apear in A3 AA990002
i want to do this by formula can anyone help me please??
Hello,
i want to generate a sequential number pressing a number
example
A B
1 AA 99
2 AA990001
3
imagine i press a buttom and it will apear in A3 AA990002
i want to do this by formula can anyone help me please??
you cant press a button and do it by formula alone.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
In B1 type AA990000
In B2
="AA"&SUBSTITUTE(B1,"AA","")+1
Copy down
if this is supposed to be dynamic and perhaps you wanted to put XX in a1 and 77 in B1
then generate
XX770001
in a1 AA in B1 99
in A2 filled down
=$A$1&$B$1&TEXT(ROWS($A$1:A1),"0000")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks