xlDynamicFilterCriteria

Specifies the filter criterion.

xlFilterAboveAverageFilter all above-average values (33)
xlFilterAllDatesInPeriodAprilFilter all dates in April (24)
xlFilterAllDatesInPeriodAugustFilter all dates in August (28)
xlFilterAllDatesInPeriodDecemberFilter all dates in December (32)
xlFilterAllDatesInPeriodFebrurayFilter all dates in February (22)
xlFilterAllDatesInPeriodJanuaryFilter all dates in January (21)
xlFilterAllDatesInPeriodJulyFilter all dates in July (27)
xlFilterAllDatesInPeriodJuneFilter all dates in June (26)
xlFilterAllDatesInPeriodMarchFilter all dates in March (23)
xlFilterAllDatesInPeriodMayFilter all dates in May (25)
xlFilterAllDatesInPeriodNovemberFilter all dates in November (31)
xlFilterAllDatesInPeriodOctoberFilter all dates in October (30)
xlFilterAllDatesInPeriodQuarter1Filter all dates in Quarter1 (17)
xlFilterAllDatesInPeriodQuarter2Filter all dates in Quarter2 (18)
xlFilterAllDatesInPeriodQuarter3Filter all dates in Quarter3 (19)
xlFilterAllDatesInPeriodQuarter4Filter all dates in Quarter4 (20)
xlFilterAllDatesInPeriodSeptemberFilter all dates in September (29)
xlFilterBelowAverageFilter all below-average values (34)
xlFilterLastMonthFilter all values related to last month (8)
xlFilterLastQuarterFilter all values related to last quarter (11)
xlFilterLastWeekFilter all values related to last week (5)
xlFilterLastYearFilter all values related to last year (14)
xlFilterNextMonthFilter all values related to next month (9)
xlFilterNextQuarterFilter all values related to next quarter (12)
xlFilterNextWeekFilter all values related to next week (6)
xlFilterNextYearFilter all values related to next year (15)
xlFilterThisMonthFilter all values related to the current month (7)
xlFilterThisQuarterFilter all values related to the current quarter (10)
xlFilterThisWeekFilter all values related to the current week (4)
xlFilterThisYearFilter all values related to the current year (13)
xlFilterTodayFilter all values related to the current date (1)
xlFilterTomorrowFilter all values related to tomorrow (3)
xlFilterYearToDateFilter all values from today until a year ago (16)
xlFilterYesterdayFilter all values related to yesterday (2)

xlFilterAboveAverage
Filter all above-average values (33)
xlFilterAllDatesInPeriodApril
Filter all dates in April (24)
xlFilterAllDatesInPeriodAugust
Filter all dates in August (28)
xlFilterAllDatesInPeriodDecember
Filter all dates in December (32)
xlFilterAllDatesInPeriodFebruray
Filter all dates in February (22)
xlFilterAllDatesInPeriodJanuary
Filter all dates in January (21)
xlFilterAllDatesInPeriodJuly
Filter all dates in July (27)
xlFilterAllDatesInPeriodJune
Filter all dates in June (26)
xlFilterAllDatesInPeriodMarch
Filter all dates in March (23)
xlFilterAllDatesInPeriodMay
Filter all dates in May (25)
xlFilterAllDatesInPeriodNovember
Filter all dates in November (31)
xlFilterAllDatesInPeriodOctober
Filter all dates in October (30)
xlFilterAllDatesInPeriodQuarter1
Filter all dates in Quarter1 (17)
xlFilterAllDatesInPeriodQuarter2
Filter all dates in Quarter2 (18)
xlFilterAllDatesInPeriodQuarter3
Filter all dates in Quarter3 (19)
xlFilterAllDatesInPeriodQuarter4
Filter all dates in Quarter4 (20)
xlFilterAllDatesInPeriodSeptember
Filter all dates in September (29)
xlFilterBelowAverage
Filter all below-average values (34)
xlFilterLastMonth
Filter all values related to last month (8)
xlFilterLastQuarter
Filter all values related to last quarter (11)
xlFilterLastWeek
Filter all values related to last week (5)
xlFilterLastYear
Filter all values related to last year (14)
xlFilterNextMonth
Filter all values related to next month (9)
xlFilterNextQuarter
Filter all values related to next quarter (12)
xlFilterNextWeek
Filter all values related to next week (6)
xlFilterNextYear
Filter all values related to next year (15)
xlFilterThisMonth
Filter all values related to the current month (7)
xlFilterThisQuarter
Filter all values related to the current quarter (10)
xlFilterThisWeek
Filter all values related to the current week (4)
xlFilterThisYear
Filter all values related to the current year (13)
xlFilterToday
Filter all values related to the current date (1)
xlFilterTomorrow
Filter all values related to tomorrow (3)
xlFilterYearToDate
Filter all values from today until a year ago (16)
xlFilterYesterday
Filter all values related to yesterday (2)

REMARKS
* Added in 2007.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top