| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto numbering with letters - re-posting question from above
Could that formula be modifed so after 26 characters, it started with A1,
B1... instead of AA, AB...? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto numbering with letters - re-posting question from above
"rayybay" wrote:
Could that formula be modifed so after 26 characters, it started with A1, B1... instead of AA, AB...? 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto numbering with letters - re-posting question from above
PERFECT!!! Thank you!
"Max" wrote: "rayybay" wrote: Could that formula be modifed so after 26 characters, it started with A1, B1... instead of AA, AB...? 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto numbering with letters - re-posting question from above
Welcome, glad to hear that
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "rayybay" wrote in message ... PERFECT!!! Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto-Numbering Occurrences Question | Excel Worksheet Functions | |||
| Numbering using letters | Excel Discussion (Misc queries) | |||
| Auto Numbering | New Users to Excel | |||
| auto posting dates | New Users to Excel | |||
| the owner of posting should be able to delete the posting | Excel Discussion (Misc queries) | |||
Hybrid Mode
