Forum Discussion

Craig_Gallagher

Copper Contributor

Apr 25, 2019

Solved

Change the row-to-row increment value when copying down a column, from +1 to +300

My formula in cell H5 is "=SLOPE('Data 300 Counts'!G903:G1200, 'Laser Pixel Data'!$H$3:$H$300)" I want to copy this down the column so that H6 is "=SLOPE('Data 300 Counts'!G1203:G1500, 'Laser Pixe...

Formulas and Functions

Apr 25, 2019

Craig_Gallagher ,

The idea is

=SLOPE(INDEX('Data 300 Counts'!G:G,903+300**(ROW()-ROW($A$5))):INDEX('Data 300 Counts'!G:G,1200+300**(ROW()-ROW($A$5))), 'Laser Pixel Data'!$H$3:$H$300)

Diamond Contributor

Apr 25, 2019

Craig_Gallagher ,

The idea is

=SLOPE(INDEX('Data 300 Counts'!G:G,903+300**(ROW()-ROW($A$5))):INDEX('Data 300 Counts'!G:G,1200+300**(ROW()-ROW($A$5))), 'Laser Pixel Data'!$H$3:$H$300)

JTaverna
Copper Contributor
Dec 04, 2019
SergeiBaklanI am working on a similar issue that is driving me nuts. I am trying to copy the formula below across many columns. This is a complex spreadsheet where we are referencing data vertically down through many rows, and then creating a horizontal map across many columns. What I basically need to do is increment the F30 to F31, F32, F33, etc... as the formula is copied across. With no dollar sign, the rows increment from F30 to G30, H30, etc., and with the dollar sign in place before F30, it freezes the F30 so that it shows up in each formula. The H15 is incrementing as it should to I15, J15, K15, etc...
=IF(ISERROR($F30),"",VLOOKUP(H15,$B$29:$F$9999,5,FALSE))
I would really appreciate any help you can provide
Craig_Gallagher
Copper Contributor
Apr 25, 2019
Yes, that did the trick, thank you.
- SergeiBaklan
  Diamond Contributor
  Apr 25, 2019
  Craig_Gallagher , you are welcome. That was misprint in the formula like 300**( instaed of 300*(
  
  Sorry for that, mistake with copy/paste.
  - Craig_Gallagher
    Copper Contributor
    Apr 25, 2019
    No trouble! I found it pretty quickly. You got me 99.9999% of the way there. Thanks again.

Resources