Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 76
Default FILTER FORMULA

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~
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Filter w/ formula LH Excel Discussion (Misc queries) 1 November 19th 08 09:06 PM
Filter a list using a formula. Charno Excel Discussion (Misc queries) 2 April 28th 08 09:15 AM
Filter Formula Josh O. Excel Worksheet Functions 9 February 2nd 07 02:31 PM
filter with formula Brian Excel Discussion (Misc queries) 1 August 22nd 06 04:39 PM
Filter formula PO Excel Worksheet Functions 4 June 15th 06 11:59 PM


All times are GMT +1. The time now is 08:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"