How to use Percentile based on a bucket list?

[Beacon28]

Hello,

I am having trouble using formulas in a smart way in excel

Basically, I am trying to calculate percentile for a range. But since my data set is huge, I dont want to select the range in percentile formula manually. my data set includes buckets and would love to be able to search for that field and then calculate percentile on a range. is that possible?

example
see attached excel file -its a small data set, but there are more buckets in the volume column. Using Excel 2007

thanks!!!

[shg]

Welcome to the forum.

What are the expected results for your example?