Expand Minimize

XlDynamicFilterCriteria Enumeration

Specifies the filter criterion.

Version Added: Excel 2007

Name

Value

Description

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.

Show:
© 2014 Microsoft