Automatic numbering with letters

R

rayybay

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!
 
R

rayybay

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!
 
R

Rick Rothstein

Give this modification to David's formula a try...

=REPT(CHAR(MOD(ROW(A1)-1,26)+65),1+(ROW(A1)-1)/26)
 
R

rayybay

FANTASTIC!!!! Thank you both!!

Rick Rothstein said:
Give this modification to David's formula a try...

=REPT(CHAR(MOD(ROW(A1)-1,26)+65),1+(ROW(A1)-1)/26)
 

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

Top