ranking; formula; excel

  1. J

    Row Ranking Not Working Correctly

    Here was have a calculated ranking in column I based on the value of column H. However, column I keeps producing #N/A on row 66. The rows are sorted from smallest to largest based on the value on column I. To troubleshoot, I've tried deleting the formulas and re-adding them; adding values to the...
  2. C

    Ranking help

    I am trying to rank students in such a way so that if they receive a zero it will not rank them it will skip over them but then if two students have the same score they will receive the same rank. I also would like it where it will not jump around with the ranks. Example of how I would like it...
  3. R

    Issue with rank formula

    Hi guys, I need a rank formula, these are the data. [/URL][/IMG] The expected result is in the green column. So, rank the same values in one (multiple values all equal the same), without jumps of numbers, and consider the different names in another rank (Pescara and Chieti). I need a formula...

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