QUARTILE Function on Sorted Data
 

I am trying to utilize the QUARTILE function on a series of investment
returns. When utilizing the complete data set (returns on 195 funds),
Quartile works fine. However, when I use Autofilter to focus on returns say
in Asia (returns on 21 funds), Quartile returns the same results as if using
the complete data set (all 195 funds). How does one get the QUARTILE
function to ignore the hidden values sorted out by the use of Autofilter? Or
do I need to take a different approach?

Thanks in advance for the help. Gerry

QUARTILE Function on Sorted Data
 

See your other post...

In article ,
Gerry Pat wrote:

I am trying to utilize the QUARTILE function on a series of investment
returns. When utilizing the complete data set (returns on 195 funds),
Quartile works fine. However, when I use Autofilter to focus on returns say
in Asia (returns on 21 funds), Quartile returns the same results as if using
the complete data set (all 195 funds). How does one get the QUARTILE
function to ignore the hidden values sorted out by the use of Autofilter? Or
do I need to take a different approach?

Thanks in advance for the help. Gerry