Incremental column addresses

[ChristineJ]

In column M is a sequential list of column addresses that I need to add to. Is there a way to use a function so that the next column address in the sequence appears automatically rather than my having to type it in?

O
P ... rather than typing in "P", it would be the column value above "plus 1"?
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
AG
AH
AI
AJ
AK
AL
AM
AN
AO
AP
AQ
continues...

 

[V_Malkoti]

Try this:

[TABLE="class: grid, width: 550, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]M[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]O[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]=SUBSTITUTE(ADDRESS(1, COLUMN(INDIRECT(M1 & 1))+1, 2), "$1", "")[/TD]
[/TR]
</tbody>[/TABLE]

 

[MrTeeny]

If you're simply starting at row 1 is column A just enter this and drag it down however many cells you want to reference

=SUBSTITUTE(ADDRESS(1,ROW(),4),"1","")

If you're starting other than A=1 just add whatever number you need to the row element of the formula

=SUBSTITUTE(ADDRESS(1,ROW()+14,4),"1","")

 

[ChristineJ]

Thanks!! Works perfectly!

 

[ChristineJ]

MrTeeny - Thanks so much! I am actually starting at M4; should have stated that. I was able to work with V-Malkoti's code before I saw yours. All working fine!

Thanks so much to both of you for the quick responses.

 

[MrTeeny]

No problem, the method I posted just references whichever ROW you've entered the formula in so entered in M4 it would show as D simply as that's row 4, if you wanted it to show as O in M4 you'd just add 11 to the ROW() i.e. =SUBSTITUTE(ADDRESS(1,ROW()+11,4),"1","") and it'd work wherever you placed it on the sheet without the need to reference some a letter