Forum Discussion
Solved
Continue Pattern (includes letters and numbers)
I'd like to continue this pattern on this spreadsheet, but every time I try to drag it it will repeat the pattern (A, B, C, D, A, B, C, D) instead of continuing with the alphabet (A, B, C, D, E...
Hi,
Please put this formula in the first cell, then drag it to the right and all the way down.
=ROW(A21)&RIGHT(B$1)
It's done by depending on the letters in the headers (Column A, Column B, etc) as a reference in the formula.
Hope that helps
Try this formula in A1 and copy to your range:
=ROW()+20&
SUBSTITUTE(ADDRESS(1,
COLUMN(),4),
1,””)
=ROW()+20&
SUBSTITUTE(ADDRESS(1,
COLUMN(),4),
1,””)