numbering

  • Thread starter Thread starter Steven Hook
  • Start date Start date
S

Steven Hook

Hi,
I need to add a column to a workbook that runs as follows A1 - A200,
B1-B200,..., Z1-Z200, AA1-AA200, all the way to 1000000 rows, I'm doing them
by hand now, but I'm sure a formula could save a LOT of mouse work.
Thanks
Steven
 
Steven,

In row 1 of your column, enter the formula

=ADDRESS(MOD(ROW()-1,200)+1,INT((ROW()-1)/200)+1,4)

and copy down as far as you want thorugh row 51,200, where it will fall
apart. (You're not going to get to 1,000,000 rows anyway, since Excel only
has 65,536 rows.)

HTH,
Bernie
MS Excel MVP
 
Back
Top