S
Sharkies
I have a large database (25000 rows) and would like to apply a filter to
it. I have 4 fields (variables) with 25000 rows (readings every second).
What I'm trying to attempt is to filter out the database at minute
intervals, that is, picking one minute per set of rows (a number of
readings per minute), choosing the closest reading to the exact minute
(e.g. 7:46:03). The problem here is that the set of readings per minute
vary from one to 20 and I need to pick only one. Is there a function or
formula in excel that you recommend trying to filter my data??
Thanks...
it. I have 4 fields (variables) with 25000 rows (readings every second).
What I'm trying to attempt is to filter out the database at minute
intervals, that is, picking one minute per set of rows (a number of
readings per minute), choosing the closest reading to the exact minute
(e.g. 7:46:03). The problem here is that the set of readings per minute
vary from one to 20 and I need to pick only one. Is there a function or
formula in excel that you recommend trying to filter my data??
Thanks...