Hello everyone,
I'm looking for a way in which I can take every nth row (B:2,B:33,B64 etc) and come out with a cumulative average.
I conducted 200 tests, each taking 62 seconds and recording results every 2 seconds. So each test is 31 rows. You can see that the "time-elapsed" (Row A) fields repeat from 2 - 64. I'm trying to take all the data I recorded at 2 seconds and create a cumulative average from it, this would then be repeated for 4, 6, 8, 10 etc seconds until I turn the 6200 rows I have now into 31 rows each representing the 2 second intervals (2,4,6,8,10 etc). I've tried some equations before but they aren't quite what I wanted. I'm wondering if any of you could help me with this?
Thanks in advance,
Will
Edit:
Kudos to tootall#6875 on the Microsoft-community discord server for this answer
Bookmarks