Hello there,

I have a large data set that I've applied autofilters to. I am looking to get various figures for the filtered data. I've used =subtotal for average, max, min, and count.

I also need to give the .25 and .75 percentile figures for the filtered data, but can't do it with subtotal. I think there's a way to do it, but I've just no idea how.

I'm hoping one of you has come across something similar and could help.

Many thanks in advance!

Brad