XlDynamicFilterCriteria XlDynamicFilterCriteria XlDynamicFilterCriteria Enum

Definition

Specifies the filter criterion.

public enum class XlDynamicFilterCriteria
public enum XlDynamicFilterCriteria
Public Enum XlDynamicFilterCriteria
Inheritance
XlDynamicFilterCriteriaXlDynamicFilterCriteriaXlDynamicFilterCriteria

Fields

xlFilterAboveAverage xlFilterAboveAverage xlFilterAboveAverage 33

Filter all above-average values.

xlFilterAllDatesInPeriodApril xlFilterAllDatesInPeriodApril xlFilterAllDatesInPeriodApril 24

Filter all dates in April.

xlFilterAllDatesInPeriodAugust xlFilterAllDatesInPeriodAugust xlFilterAllDatesInPeriodAugust 28

Filter all dates in August.

xlFilterAllDatesInPeriodDecember xlFilterAllDatesInPeriodDecember xlFilterAllDatesInPeriodDecember 32

Filter all dates in December.

xlFilterAllDatesInPeriodFebruray xlFilterAllDatesInPeriodFebruray xlFilterAllDatesInPeriodFebruray 22

Filter all dates in February.

xlFilterAllDatesInPeriodJanuary xlFilterAllDatesInPeriodJanuary xlFilterAllDatesInPeriodJanuary 21

Filter all dates in January.

xlFilterAllDatesInPeriodJuly xlFilterAllDatesInPeriodJuly xlFilterAllDatesInPeriodJuly 27

Filter all dates in July.

xlFilterAllDatesInPeriodJune xlFilterAllDatesInPeriodJune xlFilterAllDatesInPeriodJune 26

Filter all dates in June.

xlFilterAllDatesInPeriodMarch xlFilterAllDatesInPeriodMarch xlFilterAllDatesInPeriodMarch 23

Filter all dates in March.

xlFilterAllDatesInPeriodMay xlFilterAllDatesInPeriodMay xlFilterAllDatesInPeriodMay 25

Filter all dates in May.

xlFilterAllDatesInPeriodNovember xlFilterAllDatesInPeriodNovember xlFilterAllDatesInPeriodNovember 31

Filter all dates in November.

xlFilterAllDatesInPeriodOctober xlFilterAllDatesInPeriodOctober xlFilterAllDatesInPeriodOctober 30

Filter all dates in October.

xlFilterAllDatesInPeriodQuarter1 xlFilterAllDatesInPeriodQuarter1 xlFilterAllDatesInPeriodQuarter1 17

Filter all dates in Quarter1.

xlFilterAllDatesInPeriodQuarter2 xlFilterAllDatesInPeriodQuarter2 xlFilterAllDatesInPeriodQuarter2 18

Filter all dates in Quarter2.

xlFilterAllDatesInPeriodQuarter3 xlFilterAllDatesInPeriodQuarter3 xlFilterAllDatesInPeriodQuarter3 19

Filter all dates in Quarter3.

xlFilterAllDatesInPeriodQuarter4 xlFilterAllDatesInPeriodQuarter4 xlFilterAllDatesInPeriodQuarter4 20

Filter all dates in Quarter4.

xlFilterAllDatesInPeriodSeptember xlFilterAllDatesInPeriodSeptember xlFilterAllDatesInPeriodSeptember 29

Filter all dates in September.

xlFilterBelowAverage xlFilterBelowAverage xlFilterBelowAverage 34

Filter all below-average values.

xlFilterLastMonth xlFilterLastMonth xlFilterLastMonth 8

Filter all values related to last month.

xlFilterLastQuarter xlFilterLastQuarter xlFilterLastQuarter 11

Filter all values related to last quarter.

xlFilterLastWeek xlFilterLastWeek xlFilterLastWeek 5

Filter all values related to last week.

xlFilterLastYear xlFilterLastYear xlFilterLastYear 14

Filter all values related to last year.

xlFilterNextMonth xlFilterNextMonth xlFilterNextMonth 9

Filter all values related to next month.

xlFilterNextQuarter xlFilterNextQuarter xlFilterNextQuarter 12

Filter all values related to next quarter.

xlFilterNextWeek xlFilterNextWeek xlFilterNextWeek 6

Filter all values related to next week.

xlFilterNextYear xlFilterNextYear xlFilterNextYear 15

Filter all values related to next year.

xlFilterThisMonth xlFilterThisMonth xlFilterThisMonth 7

Filter all values related to the current month.

xlFilterThisQuarter xlFilterThisQuarter xlFilterThisQuarter 10

Filter all values related to the current quarter.

xlFilterThisWeek xlFilterThisWeek xlFilterThisWeek 4

Filter all values related to the current week.

xlFilterThisYear xlFilterThisYear xlFilterThisYear 13

Filter all values related to the current year.

xlFilterToday xlFilterToday xlFilterToday 1

Filter all values related to the current date.

xlFilterTomorrow xlFilterTomorrow xlFilterTomorrow 3

Filter all values related to tomorrow.

xlFilterYearToDate xlFilterYearToDate xlFilterYearToDate 16

Filter all values from today until a year ago.

xlFilterYesterday xlFilterYesterday xlFilterYesterday 2

Filter all values related to yesterday.

Applies to