Lets say I have 100 rows in column A. That would be 100 cells with a value in each. I only want the value of the difference between every 5 cells. For example, in the first cell, A5-A1, then next cell down A10-A5, A15-A10, A20-A15, etc. I want to be able to copy a formula down that would pull those values from down the sheet.
The reason is I have a value every second of time, I want a rate every minute. Every second is too much info, too noisy.