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)
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)
Yes, that did the trick, thank you.
Craig_Gallagher , you are welcome. That was misprint in the formula like 300**( instaed of 300*(
Sorry for that, mistake with copy/paste.
- No trouble! I found it pretty quickly. You got me 99.9999% of the way there. Thanks again.