Amending formula that returns letter of said row that increases column by 1 when copied down

[jack109]

Hi

I have this formula that returns the letter of the column, I'm trying to edit it so that when copied down the "letter/column reference" increase by 1

=SUBSTITUTE(ADDRESS(1,COLUMN(G6),4),"1","")

So it would be like so

G
H
I
J
K

etc

Cheers

 

[Peter_SSs]

Suppose the first formula is in D4 then you could use

=TEXTBEFORE(ADDRESS(1,COLUMN(G4)+ROWS(D$4:D4)-1,2),"$")

Or if you knew that you wanted say 10 of them

=TEXTBEFORE(ADDRESS(1,COLUMN(G4)+SEQUENCE(10)-1,2),"$")

However, I am wondering what you want this for? What comes next? It may well be that there is a better approach.