Letter Sequence in Columns - AA AB AC AD AE etc

[dunmore83]

Hi,

I have the following formula in cell K1

=LEFT(ADDRESS(ROW($AA1),COLUMN($AA1)+(COLUMNS($K1:K1)-1),4),2)

I need to copy & past this formula 6 rows to the right each time (i.e. Q1, W1, AC1 etc)

And return the following sequence in the cells;
K1 - AA
Q1 - AB
W1 - AC
AC1 - AD

The formula above is not quite achieving the desired result (currently returns AA, AG, AM, AO in the cells above)

Can someone please help to correct this problem ?

 

[Peter_SSs]

Try

=LEFT(ADDRESS(1,(COLUMNS($K1:K1)+155)/6+1,4),2)

 

[dunmore83]

Thanks

That works perfectly !

 

[Peter_SSs]

Thanks

That works perfectly !

You're welcome. Thanks for the follow-up.