Speed/Driver calculation

Hi hello, im an intern and I am using speedmeters(? spelling) and meausring avg/top speed.

I wanna exclude 15% of the slowest drivers that my 3rd party app gives me, and only calculate the average speed of the remaining 85%.


Also these brackets are nessesary, and the column may be filled more or less depending on top speeds.

Anyone good at this?

-R

You requested that I remove the image - I have done so, however you could have removed it yourself by editing the post and scrolling down to Manage Attachments.

Please replace it with something useful like a sample workbook. Images are not much use to us, really.

I wanna exclude 15% of the slowest drivers that my 3rd party app gives me, and only calculate the average speed of the remaining 85%.

In the absence of details that allow for a more specific solution, this sounds like the core of whatever solution comes up will be an AVERAGEIFS() function: https://support.microsoft.com/en-us/...8-f7c5c3001690 One of the PERCENTILE() functions (for example: https://support.microsoft.com/en-us/...e-d626debdddca ) may be useful for computing the 15th percentile (assuming that is how you want to determine "slowest 15%" or "fastest 85%").