# Incrementing column letters and row numbers at different intervals

1. ## Incrementing column letters and row numbers at different intervals

Hi all, I've got an Excel workbook with two sheets...one named "Sheet1" and one named "formulas".

In Sheet1, cells A20 through A25 look like this:

=formulas!A2
=formulas!B2
=formulas!C2
=formulas!D2
=formulas!E2
=formulas!F2

I can't seem to find a way to tell Excel that I want to autofill cell A26 on down to look like this:

=formulas!A3
=formulas!B3
=formulas!C3
=formulas!D3
=formulas!E3
=formulas!F3
=formulas!A4
=formulas!B4
=formulas!C4
=formulas!D4
=formulas!E4
=formulas!F4
=formulas!A5
=formulas!B5
=formulas!C5
=formulas!D5
=formulas!E5
=formulas!F5

and so on.

Do any of you fine folks know how I could accomplish this? Thanks!

2. ## Re: Incrementing column letters and row numbers at different intervals

Paste formula into cell A20 and fill down until you get bored.

Formula:
`Please Login or Register  to view this content.`

3. ## Re: Incrementing column letters and row numbers at different intervals

You can put this formula in cell A20 of Sheet1:

=INDEX(formulas!\$A:\$F,INT((ROWS(\$1:1)-1)/6)+2,MOD(ROWS(\$1:1)-1,6)+1)

then copy it down as far as you need to.

Hope this helps.

Pete

4. ## Re: Incrementing column letters and row numbers at different intervals

mehmetcik and Pete_UK, first let me start off by saying you guys are awesome.

I'm sorry I forgot to mention a vital piece of information. On the "formulas" sheet, column E is intentionally left blank. If I use the formulas you provided, every time column E is referenced (A24, A30, A36, A42...) a 0 is shown. How would I edit the formulas you provided to leave A24, A30, A36, A42 and so on blank instead of showing a 0?

5. ## Re: Incrementing column letters and row numbers at different intervals

You could change my formula to this:

=IF(MOD(ROWS(\$1:1)-1,6)+1=5,"",INDEX(formulas!\$A:\$F,INT((ROWS(\$1:1)-1)/6)+2,MOD(ROWS(\$1:1)-1,6)+1))

then copy down.

Hope this helps.

Pete

6. ## Re: Incrementing column letters and row numbers at different intervals

That did the trick. Very nice! Thanks for the help Pete_UK and mehmetcik!

7. ## Re: Incrementing column letters and row numbers at different intervals

You're welcome - thanks for the rep.

Pete

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1