xlPivotFilterType |
| Specifies the type of filter applied. |
| xlBefore | Filters for all dates before a specified date (31) |
| xlBeforeOrEqualTo | Filters for all dates on or before a specified date (32) |
| xlAfter | Filters for all dates after a specified date (33) |
| xlAfterOrEqualTo | Filters for all dates on or after a specified date (34) |
| xlAllDatesInPeriodJanuary | Filters for all dates in January (53) |
| xlAllDatesInPeriodFebruary | Filters for all dates in February (54) |
| xlAllDatesInPeriodMarch | Filters for all dates in March (55) |
| xlAllDatesInPeriodApril | Filters for all dates in April (56) |
| xlAllDatesInPeriodMay | Filters for all dates in May (57) |
| xlAllDatesInPeriodJune | Filters for all dates in June (58) |
| xlAllDatesInPeriodJuly | Filters for all dates in July (59) |
| xlAllDatesInPeriodAugust | Filters for all dates in August (60) |
| xlAllDatesInPeriodSeptember | Filters for all dates in September (61) |
| xlAllDatesInPeriodOctober | Filters for all dates in October (62) |
| xlAllDatesInPeriodNovember | Filters for all dates in November (63) |
| xlAllDatesInPeriodDecember | Filters for all dates in December (64) |
| xlAllDatesInPeriodQuarter1 | Filters for all dates in Quarter1 (49) |
| xlAllDatesInPeriodQuarter2 | Filters for all dates in Quarter2 (50) |
| xlAllDatesInPeriodQuarter3 | Filters for all dates in Quarter3 (51) |
| xlAllDatesInPeriodQuarter4 | Filters for all dates in Quarter 4 (52) |
| xlBottomCount | Filters for the specified number of values from the bottom of a list (2) |
| xlBottomPercent | Filters for the specified percentage of values from the bottom of a list (4) |
| xlBottomSum | Sum of the values from the bottom of the list (6) |
| xlCaptionBeginsWith | Filters for all captions beginning with the specified string (17) |
| xlCaptionContains | Filters for all captions that contain the specified string (21) |
| xlCaptionDoesNotBeginWith | Filters for all captions that do not begin with the specified string (18) |
| xlCaptionDoesNotContain | Filters for all captions that do not contain the specified string (22) |
| xlCaptionDoesNotEndWith | Filters for all captions that do not end with the specified string (20) |
| xlCaptionDoesNotEqual | Filters for all captions that do not match the specified string (16) |
| xlCaptionEndsWith | Filters for all captions that end with the specified string (19) |
| xlCaptionEquals | Filters for all captions that match the specified string (15) |
| xlCaptionIsBetween | Filters for all captions that are between a specified range of values (27) |
| xlCaptionIsGreaterThan | Filters for all captions that are greater than the specified value (23) |
| xlCaptionIsGreaterThanOrEqualTo | Filters for all captions that are greater than or match the specified value (24) |
| xlCaptionIsLessThan | Filters for all captions that are less than the specified value (25) |
| xlCaptionIsLessThanOrEqualTo | Filters for all captions that are less than or match the specified value (26) |
| xlCaptionIsNotBetween | Filters for all captions that are not between a specified range of values (28) |
| xlDateBetween | Filters for all dates that are between a specified range of dates (32) |
| xlDateLastMonth | Filters for all dates that apply to the previous month (41) |
| xlDateLastQuarter | Filters for all dates that apply to the previous quarter (44) |
| xlDateLastWeek | Filters for all dates that apply to the previous week (38) |
| xlDateLastYear | Filters for all dates that apply to the previous year (47) |
| xlDateNextMonth | Filters for all dates that apply to the next month (39) |
| xlDateNextQuarter | Filters for all dates that apply to the next quarter (42) |
| xlDateNextWeek | Filters for all dates that apply to the next week (36) |
| xlDateNextYear | Filters for all dates that apply to the next year (45) |
| xlDateThisMonth | Filters for all dates that apply to the current month (40) |
| xlDateThisQuarter | Filters for all dates that apply to the current quarter (43) |
| xlDateThisWeek | Filters for all dates that apply to the current week (37) |
| xlDateThisYear | Filters for all dates that apply to the current year (46) |
| xlDateToday | Filters for all dates that apply to the current date (34) |
| xlDateTomorrow | Filters for all dates that apply to the next day (33) |
| xlDateYesterday | Filters for all dates that apply to the previous day (35) |
| xlNotSpecificDate | Filters for all dates that do not match a specified date (30) |
| xlSpecificDate | Filters for all dates that match a specified date (29) |
| xlTopCount | Filters for the specified number of values from the top of a list (1) |
| xlTopPercent | Filters for the specified percentage of values from a list (3) |
| xlTopSum | Sum of the values from the top of the list (5) |
| xlValueDoesNotEqual | Filters for all values that do not match the specified value (8) |
| xlValueEquals | Filters for all values that match the specified value (7) |
| xlValueIsBetween | Filters for all values that are between a specified range of values (13) |
| xlValueIsGreaterThan | Filters for all values that are greater than the specified value (9) |
| xlValueIsGreaterThanOrEqualTo | Filters for all values that are greater than or match the specified value (10) |
| xlValueIsLessThan | Filters for all values that are less than the specified value (11) |
| xlValueIsLessThanOrEqualTo | Filters for all values that are less than or match the specified value (12) |
| xlValueIsNotBetween | Filters for all values that are not between a specified range of values (14) |
| xlYearToDate | Filters for all values that are within one year of a specified date (48) |
| xlBefore |
| Filters for all dates before a specified date (31) |
| xlBeforeOrEqualTo |
| Filters for all dates on or before a specified date (32) |
| xlAfter |
| Filters for all dates after a specified date (33) |
| xlAfterOrEqualTo |
| Filters for all dates on or after a specified date (34) |
| xlAllDatesInPeriodJanuary |
| Filters for all dates in January (53) |
| xlAllDatesInPeriodFebruary |
| Filters for all dates in February (54) |
| xlAllDatesInPeriodMarch |
| Filters for all dates in March (55) |
| xlAllDatesInPeriodApril |
| Filters for all dates in April (56) |
| xlAllDatesInPeriodMay |
| Filters for all dates in May (57) |
| xlAllDatesInPeriodJune |
| Filters for all dates in June (58) |
| xlAllDatesInPeriodJuly |
| Filters for all dates in July (59) |
| xlAllDatesInPeriodAugust |
| Filters for all dates in August (60) |
| xlAllDatesInPeriodSeptember |
| Filters for all dates in September (61) |
| xlAllDatesInPeriodOctober |
| Filters for all dates in October (62) |
| xlAllDatesInPeriodNovember |
| Filters for all dates in November (63) |
| xlAllDatesInPeriodDecember |
| Filters for all dates in December (64) |
| xlAllDatesInPeriodQuarter1 |
| Filters for all dates in Quarter1 (49) |
| xlAllDatesInPeriodQuarter2 |
| Filters for all dates in Quarter2 (50) |
| xlAllDatesInPeriodQuarter3 |
| Filters for all dates in Quarter3 (51) |
| xlAllDatesInPeriodQuarter4 |
| Filters for all dates in Quarter 4 (52) |
| xlBottomCount |
| Filters for the specified number of values from the bottom of a list (2) |
| xlBottomPercent |
| Filters for the specified percentage of values from the bottom of a list (4) |
| xlBottomSum |
| Sum of the values from the bottom of the list (6) |
| xlCaptionBeginsWith |
| Filters for all captions beginning with the specified string (17) |
| xlCaptionContains |
| Filters for all captions that contain the specified string (21) |
| xlCaptionDoesNotBeginWith |
| Filters for all captions that do not begin with the specified string (18) |
| xlCaptionDoesNotContain |
| Filters for all captions that do not contain the specified string (22) |
| xlCaptionDoesNotEndWith |
| Filters for all captions that do not end with the specified string (20) |
| xlCaptionDoesNotEqual |
| Filters for all captions that do not match the specified string (16) |
| xlCaptionEndsWith |
| Filters for all captions that end with the specified string (19) |
| xlCaptionEquals |
| Filters for all captions that match the specified string (15) |
| xlCaptionIsBetween |
| Filters for all captions that are between a specified range of values (27) |
| xlCaptionIsGreaterThan |
| Filters for all captions that are greater than the specified value (23) |
| xlCaptionIsGreaterThanOrEqualTo |
| Filters for all captions that are greater than or match the specified value (24) |
| xlCaptionIsLessThan |
| Filters for all captions that are less than the specified value (25) |
| xlCaptionIsLessThanOrEqualTo |
| Filters for all captions that are less than or match the specified value (26) |
| xlCaptionIsNotBetween |
| Filters for all captions that are not between a specified range of values (28) |
| xlDateBetween |
| Filters for all dates that are between a specified range of dates (32) |
| xlDateLastMonth |
| Filters for all dates that apply to the previous month (41) |
| xlDateLastQuarter |
| Filters for all dates that apply to the previous quarter (44) |
| xlDateLastWeek |
| Filters for all dates that apply to the previous week (38) |
| xlDateLastYear |
| Filters for all dates that apply to the previous year (47) |
| xlDateNextMonth |
| Filters for all dates that apply to the next month (39) |
| xlDateNextQuarter |
| Filters for all dates that apply to the next quarter (42) |
| xlDateNextWeek |
| Filters for all dates that apply to the next week (36) |
| xlDateNextYear |
| Filters for all dates that apply to the next year (45) |
| xlDateThisMonth |
| Filters for all dates that apply to the current month (40) |
| xlDateThisQuarter |
| Filters for all dates that apply to the current quarter (43) |
| xlDateThisWeek |
| Filters for all dates that apply to the current week (37) |
| xlDateThisYear |
| Filters for all dates that apply to the current year (46) |
| xlDateToday |
| Filters for all dates that apply to the current date (34) |
| xlDateTomorrow |
| Filters for all dates that apply to the next day (33) |
| xlDateYesterday |
| Filters for all dates that apply to the previous day (35) |
| xlNotSpecificDate |
| Filters for all dates that do not match a specified date (30) |
| xlSpecificDate |
| Filters for all dates that match a specified date (29) |
| xlTopCount |
| Filters for the specified number of values from the top of a list (1) |
| xlTopPercent |
| Filters for the specified percentage of values from a list (3) |
| xlTopSum |
| Sum of the values from the top of the list (5) |
| xlValueDoesNotEqual |
| Filters for all values that do not match the specified value (8) |
| xlValueEquals |
| Filters for all values that match the specified value (7) |
| xlValueIsBetween |
| Filters for all values that are between a specified range of values (13) |
| xlValueIsGreaterThan |
| Filters for all values that are greater than the specified value (9) |
| xlValueIsGreaterThanOrEqualTo |
| Filters for all values that are greater than or match the specified value (10) |
| xlValueIsLessThan |
| Filters for all values that are less than the specified value (11) |
| xlValueIsLessThanOrEqualTo |
| Filters for all values that are less than or match the specified value (12) |
| xlValueIsNotBetween |
| Filters for all values that are not between a specified range of values (14) |
| xlYearToDate |
| Filters for all values that are within one year of a specified date (48) |
| REMARKS |
| * Added in 2007. |
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited Top