View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Reitanos Reitanos is offline
external usenet poster
 
Posts: 123
Default Using Autofilter to exclude dates

Hmmm, it should work as you describe; I do this all the time and have
no problem.
Are your dates all stored as actual dates and not text?
I've just double-checked and it absolutely excludes 2/18/2008 when I
use "Does not equal 2/18" - note that the year is implied as the
current year and it will not hide 2/18/2007.
Please clarify.

On Jul 31, 1:15*pm, Ian wrote:
I'm working with data that has about 19,000 rows. The information is date
specific, and there are scores of rows for each date..
I was working with February data recently and was trying to use the
autofilter to exclude February 18 (President's Day) as in "Does not equal"
2/18/2008.

Much to my surprise it doesn't appear to work that way. It will exclude one
row of February data, but not all. I can use the "is less than" and "is
greater than" path, but it seems like a long way around. I thought I had used
the autofilter before to exclude all the rows of a specific date, but
apparently not. Any ideas out there?