Complicated Excel document using thousands of data points a day

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.

Try posting a small subset of your data, and what you want to see.

It sounds like using a SUMIF and COUNTIF function could work. You would need to sum the distance column where the speed equals a certain value, and count the number of occurances?