Skip to main content

XlTop10Filter Properties

A Top 10 filter that displays top/bottom ranked values.
Name Description
FilterType Returns the XlFilterType.Top10 value that is the current filter’s type.
FilterValue Gets or sets the actual cell value which is used to perform the comparison for the current filter.
Percent Gets or sets a value indicating whether to show values that fall in the top/bottom N percent of a column.
Top Gets or sets whether top items should be included in the "Top 10" filtering results.
Value Gets or sets a top or bottom value to use as the filter criteria.
See Also