rank list of values

  1. A

    Formula VLOOKUP while ranking values

    Hello, I have a total of 3 worksheets. On the first two, I have a formula to rank the averages of each player. And, I have created a FINAL worksheet to include player's rank and at the same time I want them to sort (lowest to highest) from their average on the previous 2 sheets. I have attached...
  2. M

    Need assistance with complex ranking / prioritizing formulas

    Hello and thank you in advance if you are able to assist me with this project. I initiated it several years ago as a spreadsheet solution to help with my ADHD. It's supposed to take a list of items and rank them in order of priority based on a number of factors. The project was never completed...
    • MrGNM
    • Thread
    • rank function rank list of values rank sort sorting
    • Replies: 2
    • Forum: Excel Questions
  3. M

    Ranking numbers challenge

    Hi. I have a column of numbers: 23 13 23 7 25 25 19 23 8 I need to rank these numbers in an adjacent column, smallest to largest, with duplicate values sub-ranked. The result column for the above list would be: 5 3 6 1 8 9 4 7 2 I can use helper columns as needed. Can't come up with the...
  4. D

    Ranking a column of data

    I have a set of results (educational assessment) and I would like the next column to rank the values. Is this easy to do?

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