Forum Discussion
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...
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)