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...