Hello,

Is there any function in Excel that returns all values from a list
above or below a certain percentage rank/percentile?

For instance, if you want the average of the 2% highest numbers in a
list? Or the sum of the 25% most expensive items in a shopping
catalogue?

It has to be a "dynamic" function, where you can just drop in a set of
figures, sort the list, add a percentile, and perform a calculation on
all the figures from the cutoff point signalled by the percentile...

Hope anyone can help me out here.

Thanks
Christian


--
chlor
------------------------------------------------------------------------
chlor's Profile: http://www.excelforum.com/member.php...o&userid=31576
View this thread: http://www.excelforum.com/showthread...hreadid=512715