Forum Discussion
Deleting multiple values from the same second
Hello all, I'm hoping someone can help with this issue I am having I have a data set which includes multiple measurements per second, and I want to filter this data set so that it only includ...
You may remove duplicates by Data-Remove Duplicates
assuming you have proper sorted data
Result is
I tried that first, but it seems excel will not recognize my time data as the same value. There must be some trailing milliseconds that I cannot see, even though I have formatted the cells to the custom h:mm:ss. Do you know of another way to truncate the data to get ride of any trailing milliseconds?
Thank you!
Or you may apply Remove Duplicates to the helper column which Subodh_Tiwari_sktneer suggested.
If you'd like not cut milliseconds but round to nearest second, when
=MROUND(A2,"00:00:01")
