XlPivotFilterType enumeration (Excel)
The type of filter applied.
| Name | Value | Description |
|---|---|---|
| xlBefore | 31 | Filters for all dates before a specified date |
| xlBeforeOrEqualTo | 32 | Filters for all dates on or before a specified date |
| xlAfter | 33 | Filters for all dates after a specified date |
| xlAfterOrEqualTo | 34 | Filters for all dates on or after a specified date |
| xlAllDatesInPeriodJanuary | 57 | Filters for all dates in January |
| xlAllDatesInPeriodFebruary | 58 | Filters for all dates in February |
| xlAllDatesInPeriodMarch | 59 | Filters for all dates in March |
| xlAllDatesInPeriodApril | 60 | Filters for all dates in April |
| xlAllDatesInPeriodMay | 61 | Filters for all dates in May |
| xlAllDatesInPeriodJune | 62 | Filters for all dates in June |
| xlAllDatesInPeriodJuly | 63 | Filters for all dates in July |
| xlAllDatesInPeriodAugust | 64 | Filters for all dates in August |
| xlAllDatesInPeriodSeptember | 65 | Filters for all dates in September |
| xlAllDatesInPeriodOctober | 66 | Filters for all dates in October |
| xlAllDatesInPeriodNovember | 67 | Filters for all dates in November |
| xlAllDatesInPeriodDecember | 68 | Filters for all dates in December |
| xlAllDatesInPeriodQuarter1 | 53 | Filters for all dates in Quarter1 |
| xlAllDatesInPeriodQuarter2 | 54 | Filters for all dates in Quarter2 |
| xlAllDatesInPeriodQuarter3 | 55 | Filters for all dates in Quarter3 |
| xlAllDatesInPeriodQuarter4 | 56 | Filters for all dates in Quarter 4 |
| xlBottomCount | 2 | Filters for the specified number of values from the bottom of a list |
| xlBottomPercent | 4 | Filters for the specified percentage of values from the bottom of a list |
| xlBottomSum | 6 | Sum of the values from the bottom of the list |
| xlCaptionBeginsWith | 17 | Filters for all captions beginning with the specified string |
| xlCaptionContains | 21 | Filters for all captions that contain the specified string |
| xlCaptionDoesNotBeginWith | 18 | Filters for all captions that don't begin with the specified string |
| xlCaptionDoesNotContain | 22 | Filters for all captions that don't contain the specified string |
| xlCaptionDoesNotEndWith | 20 | Filters for all captions that don't end with the specified string |
| xlCaptionDoesNotEqual | 16 | Filters for all captions that don't match the specified string |
| xlCaptionEndsWith | 19 | Filters for all captions that end with the specified string |
| xlCaptionEquals | 15 | Filters for all captions that match the specified string |
| xlCaptionIsBetween | 27 | Filters for all captions that are between a specified range of values |
| xlCaptionIsGreaterThan | 23 | Filters for all captions that are greater than the specified value |
| xlCaptionIsGreaterThanOrEqualTo | 24 | Filters for all captions that are greater than or match the specified value |
| xlCaptionIsLessThan | 25 | Filters for all captions that are less than the specified value |
| xlCaptionIsLessThanOrEqualTo | 26 | Filters for all captions that are less than or match the specified value |
| xlCaptionIsNotBetween | 28 | Filters for all captions that are not between a specified range of values |
| xlDateBetween | 35 | Filters for all dates that are between a specified range of dates |
| xlDateLastMonth | 45 | Filters for all dates that apply to the previous month |
| xlDateLastQuarter | 48 | Filters for all dates that apply to the previous quarter |
| xlDateLastWeek | 42 | Filters for all dates that apply to the previous week |
| xlDateLastYear | 51 | Filters for all dates that apply to the previous year |
| xlDateNextMonth | 43 | Filters for all dates that apply to the next month |
| xlDateNextQuarter | 46 | Filters for all dates that apply to the next quarter |
| xlDateNextWeek | 40 | Filters for all dates that apply to the next week |
| xlDateNextYear | 49 | Filters for all dates that apply to the next year |
| xlDateThisMonth | 44 | Filters for all dates that apply to the current month |
| xlDateThisQuarter | 47 | Filters for all dates that apply to the current quarter |
| xlDateThisWeek | 41 | Filters for all dates that apply to the current week |
| xlDateThisYear | 50 | Filters for all dates that apply to the current year |
| xlDateToday | 38 | Filters for all dates that apply to the current date |
| xlDateTomorrow | 37 | Filters for all dates that apply to the next day |
| xlDateYesterday | 39 | Filters for all dates that apply to the previous day |
| xlNotSpecificDate | 30 | Filters for all dates that don't match a specified date |
| xlSpecificDate | 29 | Filters for all dates that match a specified date |
| xlTopCount | 1 | Filters for the specified number of values from the top of a list |
| xlTopPercent | 3 | Filters for the specified percentage of values from a list |
| xlTopSum | 5 | Sum of the values from the top of the list |
| xlValueDoesNotEqual | 8 | Filters for all values that don't match the specified value |
| xlValueEquals | 7 | Filters for all values that match the specified value |
| xlValueIsBetween | 13 | Filters for all values that are between a specified range of values |
| xlValueIsGreaterThan | 9 | Filters for all values that are greater than the specified value |
| xlValueIsGreaterThanOrEqualTo | 10 | Filters for all values that are greater than or match the specified value |
| xlValueIsLessThan | 11 | Filters for all values that are less than the specified value |
| xlValueIsLessThanOrEqualTo | 12 | Filters for all values that are less than or match the specified value |
| xlValueIsNotBetween | 14 | Filters for all values that are not between a specified range of values |
| xlYearToDate | 52 | Filters for all values that are within one year of a specified date |
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.