Hello there,
I have been using this formula to include data in my standard deviation calculation every 294th row:
=STDEV.P(IF(ISNUMBER(I296:I766752), IF(MOD(ROW(I296:I766752)-ROW(I296), 294)=0, I296:I766752)))
This works as hoped for. However, I now want to expand the range of inclusion by including Column G so that after the formula has finished with Column I it will then continue on with the same exact steps on Column G (Same starting row and end) Basically, just as if Column G's data was attached to the bottom of Column I in the first place. In case anyone wonders why I don't do that, my data combined hits the hard limit of Excel's rows.
Thank you so much to anyone that can help me here. I have tried my hand at making it work to no avail.
Bookmarks