Assuming that your times are in column A starting with A2, and that
they are in sequence, put this formula in a helper column next to your
data (eg in E2):

=IF(TIME(HOUR(A2),MINUTE(A2),0)<TIME(HOUR(A1),MIN UTE(A1),0),"yes","")

Copy this down, and you will get a series of blank cells and cells
with "yes" - these occur at every change of minutes. You can now apply
a filter to column E to get what you want - select "yes" from the
filter pull-down.

Hope this helps.

Pete

On Mar 28, 6:37*am, Sharkies
wrote:
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...

--
Sharkies