subsets of a set

  1. D

    Return true/false for each row for the maximum of a subset data in an array

    Hi, I have the following data where I need to return whether I am on the maximum row based on multiple criteria I will have the formula in the formula column for each row in the example below with a TRUE or FALSE. In the example below, I should see TRUE in Rows 2 and 15. Basically for each...
  2. 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