Drag formula to the right incrementing by 8

[FryGirl]

I have a formula I'm dragging to the right. I need to increment by 8 rows as the formula extends to the right.

=IF($G16<>"",$G16,"")
=IF($G24<>"",$G24,"")
=IF($G32<>"",$G32,"")
etc...

How can this be accomplished?

 

[Peter_SSs]

You don't say where these formulas are going, but suppose the first one is in column J, then try this, dragged right.
Also adjust the '1000' as required for the end of your data.

=IF(INDEX($G16:$G1000,COLUMNS($J:J)*8-7)="","",INDEX($G16:$G1000,COLUMNS($J:J)*8-7))

Also, if the values in column G are all text or blank (ie not numerical) then this should suffice
=INDEX($G16:$G1000,COLUMNS($J:J)*8-7)&""

 

[FryGirl]

Thank you Peter. Sorry about that. The first formula is in F7, but just adjusted the column and it works great. I used the first formula as the data is both text and numbers.

 

[Peter_SSs]

Thank you Peter. Sorry about that. The first formula is in F7, but just adjusted the column and it works great. I used the first formula as the data is both text and numbers.

OK, great. Thanks for the follow-up.

 

[tyija1995]

Another method using INDIRECT:

F7:

IF(INDIRECT(ADDRESS(8*COLUMN()-32,7))<>"",INDIRECT(ADDRESS(8*COLUMN()-32,7)),"")

When dragged across columns this augments the address by 8 rows, looking at G16 for the first input (F7) then increasing by 8 rows per column spanned (e.g. formula in G7 will refer to G24...)

 

[FryGirl]

Thank you tyija1995 for your suggestion, but I'd rather stay away from Indirect since it is volatile.