Excel 365 help: How to dtermine average of bottom 1% of data?

Soldato
Joined
7 Jan 2007
Posts
10,607
Location
Sussex, UK
I am attempting to do some gaming benchmarks, I have a log of Frames Per Second.

I want to determine what my min 1% value is, I assume this would be an average of the values from 0% to 1%?

How would I go about this?
 
Thanks guys, I did more fiddling and used conditional formatting to fill in a different colour all the bottom 1% values, it confirms the PERCEBTILE Formula is the one I want.
 
Back
Top Bottom