Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how I exclude weekend dates | Setting up and Configuration of Excel | |||
How do I Exclude a list of dates in a date calculation? | Excel Worksheet Functions | |||
Exclude dates from a sum formula | Excel Worksheet Functions | |||
filtering a list to exclude 2 different dates | Excel Worksheet Functions | |||
I need to exclude duplicate patient names for dates of service is. | Excel Discussion (Misc queries) |