Auto numbering with letters - re-posting question from above

  • Thread starter Thread starter rayybay
  • Start date Start date
R

rayybay

Could that formula be modifed so after 26 characters, it started with A1,
B1... instead of AA, AB...?
 
rayybay said:
Could that formula be modifed so after 26 characters, it started with A1,
B1... instead of AA, AB...?
Click to expand...

Try this in any starting cell, say in B2:
=IF(ROWS($1:1)>26,CHAR(MOD(ROWS($1:1)-1,26)+65)&INT((ROWS($1:1)-1)/26),CHAR(MOD(ROWS($1:1)-1,26)+65))
Copy down as far as required.

The expression will return the series:
A,B, ... Z,A1,B1, ... Z1,A2,B2, ... Z2,A3,B3 ... and so on, all the way

---
 
PERFECT!!! Thank you!

Max said:
Try this in any starting cell, say in B2:
=IF(ROWS($1:1)>26,CHAR(MOD(ROWS($1:1)-1,26)+65)&INT((ROWS($1:1)-1)/26),CHAR(MOD(ROWS($1:1)-1,26)+65))
Copy down as far as required.

The expression will return the series:
A,B, ... Z,A1,B1, ... Z1,A2,B2, ... Z2,A3,B3 ... and so on, all the way

---
Click to expand...
 
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

Need Major Help on the Macro 12
Find exact value using LOOKUP 7
Auto Numbering sequence -- AA, AB instead of AA, BB? 1
Automatic numbering with letters 5
How can I increase succesive rows by alphabet rather than number? 3
Formula converts value into Feet, Inches & Fraction of an Inch 6
Re counting 9
Sumproduct frustrates me to no end. 13

Back
Top