Filtering unwanted data

[marsc038]

Hello,

I'm using a data logging software and accidentally set the sample rate to 100milliseconds as opposed to 1 second, as a result I have an excessively large data set to analyse in excel and was hoping to remove all data points between each second.

Here is an example
time (ms) temperature
14000 19.13
14100 19.14
14200 19.14
14300 19.14
14400 19.14
14500 19.15
14600 19.15
14700 19.15
14800 19.15
14900 19.15
15000 19.15

I wish to remove all points between 14000 and 15000 so that I can rewrite this data in the form

time (s) Temperature
14 19.13
15 19.15

Any assistance is greatly appreciated
Thanks

[Kaper]

in the first column next to your data write:

Please Login or Register  to view this content.

copy down.
autofilter and delete all rows with FALSEs
if you do not have header row (or more than 1 header - change 2 into 1 or 3 or ...)

[marsc038]

Thanks very much