Static $tStatic nextGets the average that was computed the last time the filter was applied or 0 if any errors or all non-numeric values were found when applying the filter.
Gets or sets the value indicating whether to filter in values below or above the average of the data range. AboveAverage to show cells above the average of the data range; BelowAverage to show cells below the average.
InvalidEnumArgumentException The value assigned is not defined in the AverageFilterType enumeration.
Static compareStatic compareStatic equalsStatic equalsStatic getStatic getStatic getStatic reference
Represents a filter which can filter data based on whether the data is below or above the average of the entire data range.
See
WorksheetTableColumn.filter