have a very long list of data of temperatures recorded at one minute intervals. There is a date and time in one column and the temperature in the other. The columns are approximately 25K rows long.
I have discovered the data was actually collected every 3 minutes, so one third of my data is duplicated.
So how do I create a new set of columns that only includes every third row of data. If there is a way to do this not using macros it would be prefered. But I can manage if a macro is the only way.
I am a Mac user
Thanks
I have discovered the data was actually collected every 3 minutes, so one third of my data is duplicated.
So how do I create a new set of columns that only includes every third row of data. If there is a way to do this not using macros it would be prefered. But I can manage if a macro is the only way.
I am a Mac user
Thanks