Hi,

Everyday I export an excel file and it comes out with thousands and thousands of data points. It is from the equipment I use. From when I turn the equipment to when I turn it off, it takes 5 measurements a second. So this is why I have thousands and thousands of data points.

In one column I have the time, the second column I have the current speed at that precise time, and in the third column I have the distance.

What i want to work out is if I pick a certain speed the equipment is at, I can then (from the formatting) work at how many efforts at that speed, the time spent at that speed and how much distance has been covered at that speed also.

For it too be classed as a certain a speed, there has to be a minimum of 5 data points in a row of that same speed. How can I on excel, work out this?

I hope this makes sense.