Export (0) Print
Expand All
Expand Minimize

XlDynamicFilterCriteria Enumeration

Office 2007
Specifies the filter criterion.

Version Information
 Version Added:  Excel 2007

NameValueDescription
xlFilterAboveAverage33Filter all above-average values.
xlFilterAllDatesInPeriodApril24Filter all dates in April.
xlFilterAllDatesInPeriodAugust28Filter all dates in August.
xlFilterAllDatesInPeriodDecember32Filter all dates in December.
xlFilterAllDatesInPeriodFebruray22Filter all dates in February.
xlFilterAllDatesInPeriodJanuary21Filter all dates in January.
xlFilterAllDatesInPeriodJuly27Filter all dates in July.
xlFilterAllDatesInPeriodJune26Filter all dates in June.
xlFilterAllDatesInPeriodMarch23Filter all dates in March.
xlFilterAllDatesInPeriodMay25Filter all dates in May.
xlFilterAllDatesInPeriodNovember31Filter all dates in November.
xlFilterAllDatesInPeriodOctober30Filter all dates in October.
xlFilterAllDatesInPeriodQuarter117Filter all dates in Quarter1.
xlFilterAllDatesInPeriodQuarter218Filter all dates in Quarter2.
xlFilterAllDatesInPeriodQuarter319Filter all dates in Quarter3.
xlFilterAllDatesInPeriodQuarter420Filter all dates in Quarter4.
xlFilterAllDatesInPeriodSeptember29Filter all dates in September.
xlFilterBelowAverage34Filter all below-average values.
xlFilterLastMonth8Filter all values related to last month.
xlFilterLastQuarter11Filter all values related to last quarter.
xlFilterLastWeek5Filter all values related to last week.
xlFilterLastYear14Filter all values related to last year.
xlFilterNextMonth9Filter all values related to next month.
xlFilterNextQuarter12Filter all values related to next quarter.
xlFilterNextWeek6Filter all values related to next week.
xlFilterNextYear15Filter all values related to next year.
xlFilterThisMonth7Filter all values related to the current month.
xlFilterThisQuarter10Filter all values related to the current quarter.
xlFilterThisWeek4Filter all values related to the current week.
xlFilterThisYear13Filter all values related to the current year.
xlFilterToday1Filter all values related to the current date.
xlFilterTomorrow3Filter all values related to tomorrow.
xlFilterYearToDate16Filter all values from today until a year ago.
xlFilterYesterday2Filter all values related to yesterday.


Community Additions

ADD
Show:
© 2014 Microsoft