Filtering Time Stamp Data - every 100th data group

Greetings!

This is my first time posting to this forum. I'm a longtime user of Excel, though not advanced; I'd say intermediate.

I have to sort and plot roughly a year's worth of data (some of it collected as frequently as every 10 seconds) and it's more data than is necessary to complete the task. Is there a straightforward way to pluck every, say, 100th data point and copy / paste to a new sheet, or delete the remainder?

I assume this falls under programming / macros, but if there is a simple solution, I'm all eyes!

thanks,

P

Try this

Please Login or Register  to view this content.