percentrank.inc

  1. R

    percentrank.inc

    I have just under 600k rows of data, all values, no formulas. I am trying to do a percentrank.inc for one column of data and it's taking 20 minutes to do it. I have an absolute beast of a machine - AMD Ryzen Threadripper, using all 32 cores, with 32gb of 2666mhz ddr4. How can it possibly take...
  2. L

    Changing Percentile Rank Ranges

    Hello, So I have a large list of data that is sorted by month and there are about 200 rows of data for each month. To clarify, Column A is a list of the dates and so because there are 200 lines of data for each month, there will be 200 entries of the same date directly to the left of the data...
  3. M

    Aggregate/subset PercentRank() functionality

    We use PERCENTILERANK.INC() in Excel with no issues. The columns below labeled "Pctl Inc" use this formula: =PERCENTRANK.INC($B$2:$B$6,B2,3) However, in other cases we are looking for subset percent rank functionality (i.e. rank a subset of the values based on some other condition/filter). We...

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