75th

  1. E

    75th percentile of filtered data

    I have a set of data in an excel spreadsheet that I have filtered. I would like to find the 75th percentile of some of the data, but I do not want to pickup the “hidden/filtered” rows in the data set.Does anyone know a formula that circumvents this? Thank you!
  2. A

    Formula that searches for item name and calculates 75th percentile of price for all quantity?

    Hello, I am trying to pull data from another large spreadsheet (thousands of rows) which is currently sorted to look something like this; A === B === C === D Item === Quantity === Price === Running Total Qty. Apple === 50 === $2.00 === 50 Apple === 100 === $2.25 === 150 Apple === 75 ===...
  3. A

    Formula that searches for item name and calculates 75th percentile of another variable?

    Hello, I am trying to pull data from another large spreadsheet (thousands of rows) which is currently sorted to look something like this; A === B === C === D Item === Quantity === Price === Running Total Qty. Apple === 50 === $2.00 === 50 Apple === 100 === $2.25 === 150 Apple === 75 === $2.75...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top