XlDynamicFilterCriteria enumeration
Office 2013 and later
Specifies the filter criterion.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
| Member name | Description | |
|---|---|---|
| xlFilterToday | Filter all values related to the current date. | |
| xlFilterYesterday | Filter all values related to yesterday. | |
| xlFilterTomorrow | Filter all values related to tomorrow. | |
| xlFilterThisWeek | Filter all values related to the current week. | |
| xlFilterLastWeek | Filter all values related to last week. | |
| xlFilterNextWeek | Filter all values related to next week. | |
| xlFilterThisMonth | Filter all values related to the current month. | |
| xlFilterLastMonth | Filter all values related to last month. | |
| xlFilterNextMonth | Filter all values related to next month. | |
| xlFilterThisQuarter | Filter all values related to the current quarter. | |
| xlFilterLastQuarter | Filter all values related to last quarter. | |
| xlFilterNextQuarter | Filter all values related to next quarter. | |
| xlFilterThisYear | Filter all values related to the current year. | |
| xlFilterLastYear | Filter all values related to last year. | |
| xlFilterNextYear | Filter all values related to next year. | |
| xlFilterYearToDate | Filter all values from today until a year ago. | |
| xlFilterAllDatesInPeriodQuarter1 | Filter all dates in Quarter1. | |
| xlFilterAllDatesInPeriodQuarter2 | Filter all dates in Quarter2. | |
| xlFilterAllDatesInPeriodQuarter3 | Filter all dates in Quarter3. | |
| xlFilterAllDatesInPeriodQuarter4 | Filter all dates in Quarter4. | |
| xlFilterAllDatesInPeriodJanuary | Filter all dates in January. | |
| xlFilterAllDatesInPeriodFebruray | Filter all dates in February. | |
| xlFilterAllDatesInPeriodMarch | Filter all dates in March. | |
| xlFilterAllDatesInPeriodApril | Filter all dates in April. | |
| xlFilterAllDatesInPeriodMay | Filter all dates in May. | |
| xlFilterAllDatesInPeriodJune | Filter all dates in June. | |
| xlFilterAllDatesInPeriodJuly | Filter all dates in July. | |
| xlFilterAllDatesInPeriodAugust | Filter all dates in August. | |
| xlFilterAllDatesInPeriodSeptember | Filter all dates in September. | |
| xlFilterAllDatesInPeriodOctober | Filter all dates in October. | |
| xlFilterAllDatesInPeriodNovember | Filter all dates in November. | |
| xlFilterAllDatesInPeriodDecember | Filter all dates in December. | |
| xlFilterAboveAverage | Filter all above-average values. | |
| xlFilterBelowAverage | Filter all below-average values. |
Show: