Edit

Share via

Excel.TopBottomSelectionType enum

  • Reference
Package:
excel

A simple enum for top/bottom filters to select whether to filter by the top N or bottom N percent, number, or sum of values.

Remarks

[ API set: ExcelApi 1.12 ]

Fields

items = "Items"

Filter the top/bottom N number of items as measured by the chosen value.
percent = "Percent"

Filter the top/bottom N percent of items as measured by the chosen value.
sum = "Sum"

Filter the top/bottom N sum as measured by the chosen value.