If you are using the Percentile function to make the calculation it does not
support "Visible cells only calculations". Before I try for a solution can
you show me how you are calculating percentiles?


--
Cheers,
Shane Devenshire


"Kaspr" wrote:

I have a table with 7 columns and 60,000 rows. When I filter column 5 (finite
number of different values), columns 6 & 7 have averages and percentiles set
for them at the bottom.

2 problems:
1. Selecting a filter loses the averages and %'s (I cut and move to the top
with a freeze on the panes, seems to fix this).
2. The averages and %'s do not adjust to the data now displayed. Out of
60,000 rows, around 8,000 are visible, but it is still averaging all of them.

How do I get the averages and %'s to self adjust.