xlDynamicFilterCriteria |
Specifies the filter criterion. |
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) |
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. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top