| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic numbering with letters
I need to automatic number using letters instead of numbers, but after "Z" I
need the lettering to be AA, BB, CC, DD ... and should it go over ZZ, I need it to be AAA, BBB, CCC, etc. Any help would be fantastic. Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic numbering with letters
=REPT(CHAR(MOD(ROW()-1,26)+65),1+(ROW()-1)/26)
-- David Biddulph "rayybay" wrote in message ... I need to automatic number using letters instead of numbers, but after "Z" I need the lettering to be AA, BB, CC, DD ... and should it go over ZZ, I need it to be AAA, BBB, CCC, etc. Any help would be fantastic. Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic numbering with letters
This only allows me to start in cell A1, but with my title rows, I have it
starting in A7. Can the formula be modified to allow me to start with A in A7 instead of G? Thanks! "David Biddulph" wrote: =REPT(CHAR(MOD(ROW()-1,26)+65),1+(ROW()-1)/26) -- David Biddulph "rayybay" wrote in message ... I need to automatic number using letters instead of numbers, but after "Z" I need the lettering to be AA, BB, CC, DD ... and should it go over ZZ, I need it to be AAA, BBB, CCC, etc. Any help would be fantastic. Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic numbering with letters
Give this modification to David's formula a try...
=REPT(CHAR(MOD(ROW(A1)-1,26)+65),1+(ROW(A1)-1)/26) -- Rick (MVP - Excel) "rayybay" wrote in message ... This only allows me to start in cell A1, but with my title rows, I have it starting in A7. Can the formula be modified to allow me to start with A in A7 instead of G? Thanks! "David Biddulph" wrote: =REPT(CHAR(MOD(ROW()-1,26)+65),1+(ROW()-1)/26) -- David Biddulph "rayybay" wrote in message ... I need to automatic number using letters instead of numbers, but after "Z" I need the lettering to be AA, BB, CC, DD ... and should it go over ZZ, I need it to be AAA, BBB, CCC, etc. Any help would be fantastic. Thanks! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic numbering with letters
Use ROW(A1) in the formula, instead of ROW()
-- David Biddulph "rayybay" wrote in message ... This only allows me to start in cell A1, but with my title rows, I have it starting in A7. Can the formula be modified to allow me to start with A in A7 instead of G? Thanks! "David Biddulph" wrote: =REPT(CHAR(MOD(ROW()-1,26)+65),1+(ROW()-1)/26) -- David Biddulph "rayybay" wrote in message ... I need to automatic number using letters instead of numbers, but after "Z" I need the lettering to be AA, BB, CC, DD ... and should it go over ZZ, I need it to be AAA, BBB, CCC, etc. Any help would be fantastic. Thanks! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic numbering with letters
FANTASTIC!!!! Thank you both!!
"Rick Rothstein" wrote: Give this modification to David's formula a try... =REPT(CHAR(MOD(ROW(A1)-1,26)+65),1+(ROW(A1)-1)/26) -- Rick (MVP - Excel) "rayybay" wrote in message ... This only allows me to start in cell A1, but with my title rows, I have it starting in A7. Can the formula be modified to allow me to start with A in A7 instead of G? Thanks! "David Biddulph" wrote: =REPT(CHAR(MOD(ROW()-1,26)+65),1+(ROW()-1)/26) -- David Biddulph "rayybay" wrote in message ... I need to automatic number using letters instead of numbers, but after "Z" I need the lettering to be AA, BB, CC, DD ... and should it go over ZZ, I need it to be AAA, BBB, CCC, etc. Any help would be fantastic. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto numbering with letters - re-posting question from above | Excel Discussion (Misc queries) | |||
| Numbering using letters | Excel Discussion (Misc queries) | |||
| Automatic Numbering | Excel Worksheet Functions | |||
| Automatic Numbering | Excel Discussion (Misc queries) | |||
| Automatic Numbering. | Excel Discussion (Misc queries) | |||
Linear Mode
