FILTER FORMULA

[Teddy-B]

Hello Everyone:
I have a long list of data that is time-stamped in column I. In cell
P1 I have one date/time listed (01-17-09 02:00). In cell P2 I have another
date/time listed (01-18-09 02:00). I want a filterto show all time-stamped
data that does not fall between the two specified date/times. I plan on doing
the filter and then deleting the data left and then showing the rest of the
data which is all I need because I only care about transactions that are
time-stamped between the two times.
What is my advanced filter formula? Is there an easier way to delete
the info I don't want?
~Merci~

 

[Max]

.. I only care about transactions that are time-stamped between the two times

To achieve the above, with P1/P2 housing the start/end date-times
Assuming real date-times in I2 down
you could place this in say, J2:
=IF(AND(I2>=$P$1,I2<=$P$2),"x","")
Copy down all the way to flag it. Then apply autofilter on col J, choose "x"
to get the desired results
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik