Error while calculating maximum value in a series

Question

I have a long series of numeric values. I want to find the maximum and minimum values of that series. I have used MIN and MAX functions to obtain the correct output but my series contains some 0 (zero) values so I used filter to find the maximum and minimum of that series excluding 0.

When I filter 0 from the series and calculate maximum and minimum it shows correct minimum value but the maximum value of the series is changed.

Why has the maximum value changed while I have only filtered out 0 from the series?

Answer 1

A PivotTable is not subject to the 10K limitation that a filter is. Max of Series in Σ Values should show the result you require.