XlDynamicFilterCriteria Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Specifies the filter criterion.
public enum class XlDynamicFilterCriteriapublic enum XlDynamicFilterCriteriaPublic Enum XlDynamicFilterCriteria- Inheritance
-
XlDynamicFilterCriteria
Fields
| Name | Value | Description |
|---|---|---|
| xlFilterToday | 1 | Filter all values related to the current date. |
| xlFilterYesterday | 2 | Filter all values related to yesterday. |
| xlFilterTomorrow | 3 | Filter all values related to tomorrow. |
| xlFilterThisWeek | 4 | Filter all values related to the current week. |
| xlFilterLastWeek | 5 | Filter all values related to last week. |
| xlFilterNextWeek | 6 | Filter all values related to next week. |
| xlFilterThisMonth | 7 | Filter all values related to the current month. |
| xlFilterLastMonth | 8 | Filter all values related to last month. |
| xlFilterNextMonth | 9 | Filter all values related to next month. |
| xlFilterThisQuarter | 10 | Filter all values related to the current quarter. |
| xlFilterLastQuarter | 11 | Filter all values related to last quarter. |
| xlFilterNextQuarter | 12 | Filter all values related to next quarter. |
| xlFilterThisYear | 13 | Filter all values related to the current year. |
| xlFilterLastYear | 14 | Filter all values related to last year. |
| xlFilterNextYear | 15 | Filter all values related to next year. |
| xlFilterYearToDate | 16 | Filter all values from today until a year ago. |
| xlFilterAllDatesInPeriodQuarter1 | 17 | Filter all dates in Quarter1. |
| xlFilterAllDatesInPeriodQuarter2 | 18 | Filter all dates in Quarter2. |
| xlFilterAllDatesInPeriodQuarter3 | 19 | Filter all dates in Quarter3. |
| xlFilterAllDatesInPeriodQuarter4 | 20 | Filter all dates in Quarter4. |
| xlFilterAllDatesInPeriodJanuary | 21 | Filter all dates in January. |
| xlFilterAllDatesInPeriodFebruray | 22 | Filter all dates in February. |
| xlFilterAllDatesInPeriodMarch | 23 | Filter all dates in March. |
| xlFilterAllDatesInPeriodApril | 24 | Filter all dates in April. |
| xlFilterAllDatesInPeriodMay | 25 | Filter all dates in May. |
| xlFilterAllDatesInPeriodJune | 26 | Filter all dates in June. |
| xlFilterAllDatesInPeriodJuly | 27 | Filter all dates in July. |
| xlFilterAllDatesInPeriodAugust | 28 | Filter all dates in August. |
| xlFilterAllDatesInPeriodSeptember | 29 | Filter all dates in September. |
| xlFilterAllDatesInPeriodOctober | 30 | Filter all dates in October. |
| xlFilterAllDatesInPeriodNovember | 31 | Filter all dates in November. |
| xlFilterAllDatesInPeriodDecember | 32 | Filter all dates in December. |
| xlFilterAboveAverage | 33 | Filter all above-average values. |
| xlFilterBelowAverage | 34 | Filter all below-average values. |