Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you number Rows A-Z then AA-ZZ
I need to list the rows with A, B, C, at the start and then continuing with
AA, BB, CC - any suggestions please - fill down doesn't work! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you number Rows A-Z then AA-ZZ
In A1 enter:
=LEFT(ADDRESS(COLUMN(),ROW(),4),LEN(ADDRESS(COLUMN (),ROW(),4))-1) and copy down -- Gary''s Student - gsnu200790 "Rebecca Potter" wrote: I need to list the rows with A, B, C, at the start and then continuing with AA, BB, CC - any suggestions please - fill down doesn't work! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you number Rows A-Z then AA-ZZ
Brilliant - what a star - many thanks for that.
Regards, Rebecca "Gary''s Student" wrote: In A1 enter: =LEFT(ADDRESS(COLUMN(),ROW(),4),LEN(ADDRESS(COLUMN (),ROW(),4))-1) and copy down -- Gary''s Student - gsnu200790 "Rebecca Potter" wrote: I need to list the rows with A, B, C, at the start and then continuing with AA, BB, CC - any suggestions please - fill down doesn't work! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you number Rows A-Z then AA-ZZ
This works for Excel 2007. For previous versions of Excel, the equation
fails after IV. If you are using an older verison of Excel, try this macro: Sub alphas() alph = "A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y ,Z" v = Split(alph, ",") icl = 1 For i = 0 To 25 Cells(i + 1, icl).Value = v(i) Next irw = 27 For i = 0 To 25 For j = 0 To 25 Cells(irw, icl).Value = v(i) & v(j) irw = irw + 1 Next Next End Sub -- Gary''s Student - gsnu200790 "Rebecca Potter" wrote: Brilliant - what a star - many thanks for that. Regards, Rebecca "Gary''s Student" wrote: In A1 enter: =LEFT(ADDRESS(COLUMN(),ROW(),4),LEN(ADDRESS(COLUMN (),ROW(),4))-1) and copy down -- Gary''s Student - gsnu200790 "Rebecca Potter" wrote: I need to list the rows with A, B, C, at the start and then continuing with AA, BB, CC - any suggestions please - fill down doesn't work! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count number of rows, where non relevant rows are hidden | Excel Discussion (Misc queries) | |||
Get number of rows that data uses, including blank rows | Excel Discussion (Misc queries) | |||
Get number of rows that data takes up, including blank rows | Excel Worksheet Functions | |||
Need number of rows | New Users to Excel | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) |