'How do I in Excel compare datapoints and based on them decided what should be done with another
I have a really large dataset with a column showing (date and time), X-coordinates the object, Y-coordinates the object, Z-coordinates the object, and speed the object.
There are around 37000 rows and the dataset.
The data measure and objects speed 50 times pr sec however it did not write the milliseconds only whole sec therefore I have 50 rows that have the same time but different XYZ and speed values.
Here's my question: is there a way I can get the average speed for every second so I can insert it into a line graph?
Hope it makes sense
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|