percentrank zeros blanks

  1. G

    Excel and/or Access ranking questions

    Thanks in advance for taking the time to read this! I have a rather large data set, containing over 20,000 records and I am looking to calculate the percentile ranking of 10 to 20 different statistics for each record, in each category, if the statistic exists. Of these 20,000 records, I...
  2. S

    Loop down by group, Loop Across by condition

    This is omething that is fairly easy to do in a spreadsheet by hand. But I am not sure how to write it into a macro as it becomes part of a bigger macro. IN the attached spreadsheet you can see what I am trying to acheive. I aim to use Percentrank by group and then across the columns. There are...
  3. B

    percentrank that doesn't count blanks

    I have an array of numbers that includes blanks and zeros. The zeros are legitimate values, but the blanks are "missing", so they are different. I want a percentrank of all of the values that are not blank. When I run just a normal percentrank function it treats all of the blanks as zero...

This Week's Hot Topics

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
Top