Forum Discussion

katie_lacy's avatar
katie_lacy
Copper Contributor
Jul 11, 2019
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...
excel
Formulas and Functions
  • Haytham Amairah's avatar
    Haytham Amairah
    Jul 11, 2019

    katie_lacy

     

    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

     

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Jul 11, 2019

katie_lacy

 

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

 

Resources