Edit

XlDynamicFilterCriteria Enum

  • Reference

Definition

Namespace:
Microsoft.Office.Interop.Excel
Assembly:
Microsoft.Office.Interop.Excel.dll

Specifies the filter criterion.

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

Fields

xlFilterAboveAverage 33

Filter all above-average values.
xlFilterAllDatesInPeriodApril 24

Filter all dates in April.
xlFilterAllDatesInPeriodAugust 28

Filter all dates in August.
xlFilterAllDatesInPeriodDecember 32

Filter all dates in December.
xlFilterAllDatesInPeriodFebruray 22

Filter all dates in February.
xlFilterAllDatesInPeriodJanuary 21

Filter all dates in January.
xlFilterAllDatesInPeriodJuly 27

Filter all dates in July.
xlFilterAllDatesInPeriodJune 26

Filter all dates in June.
xlFilterAllDatesInPeriodMarch 23

Filter all dates in March.
xlFilterAllDatesInPeriodMay 25

Filter all dates in May.
xlFilterAllDatesInPeriodNovember 31

Filter all dates in November.
xlFilterAllDatesInPeriodOctober 30

Filter all dates in October.
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.
xlFilterAllDatesInPeriodSeptember 29

Filter all dates in September.
xlFilterBelowAverage 34

Filter all below-average values.
xlFilterLastMonth 8

Filter all values related to last month.
xlFilterLastQuarter 11

Filter all values related to last quarter.
xlFilterLastWeek 5

Filter all values related to last week.
xlFilterLastYear 14

Filter all values related to last year.
xlFilterNextMonth 9

Filter all values related to next month.
xlFilterNextQuarter 12

Filter all values related to next quarter.
xlFilterNextWeek 6

Filter all values related to next week.
xlFilterNextYear 15

Filter all values related to next year.
xlFilterThisMonth 7

Filter all values related to the current month.
xlFilterThisQuarter 10

Filter all values related to the current quarter.
xlFilterThisWeek 4

Filter all values related to the current week.
xlFilterThisYear 13

Filter all values related to the current year.
xlFilterToday 1

Filter all values related to the current date.
xlFilterTomorrow 3

Filter all values related to tomorrow.
xlFilterYearToDate 16

Filter all values from today until a year ago.
xlFilterYesterday 2

Filter all values related to yesterday.

Applies to