Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

XlAutoFilterOperator Enumeration

Office 2007
Specifies the operator to use to associate two criteria applied by a filter.

Version Information
 Version Added:  Excel 2007

NameValueDescription
xlAnd1Logical AND of Criteria1 and Criteria2.
xlBottom10Items4Lowest-valued items displayed (number of items specified in Criteria1).
xlBottom10Percent6Lowest-valued items displayed (percentage specified in Criteria1).
xlFilterCellColor8Color of the cell
xlFilterDynamic11Dynamic filter
xlFilterFontColor9Color of the font
xlFilterIcon10Filter icon
xlFilterValues7Filter values
xlOr2Logical OR of Criteria1 or Criteria2.
xlTop10Items3Highest-valued items displayed (number of items specified in Criteria1).
xlTop10Percent5Highest-valued items displayed (percentage specified in Criteria1).


Community Additions

Show:
© 2014 Microsoft