Export (0) Print
Expand All
Expand Minimize

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

ADD
Show:
© 2014 Microsoft