rank testscores

  1. B

    RANK Solution needed please :)

    Hello All, Im sure you will be able able to help with the following question: I am trying to RANK a list of data but where the number maybe the same how can i get the formula to not have duplicates... So far example below i want James to be ranked 4th and Sally 5th even though they both had...
  2. D

    Rank within a group & within a sub-group problem

    Using Excel 2010, RANK.EQ works fine for showing a rank within a range. However I also want to work out the rank within a sub-group of the range based on a condition. I can't figure out how to do this, any ideas? The table below shows what I am after: Excel 2010<table rules="all"...
  3. A

    How to allocate data based on preferences and ranks

    <table style="border-collapse: collapse; width: 403pt;" border="0" cellpadding="0" cellspacing="0" width="535"><col style="width: 22pt;" width="29"> <col style="width: 33pt;" width="44"> <col style="width: 34pt;" span="6" width="45"> <col style="width: 48pt;" span="3" width="64"> <tbody><tr...
  4. S

    Rank test scores, in descening order but, omitt values below a specified cut-off point

    Hello, I need to run a macro to rank test scores in descending order but I would like to omitt values below a specific value, so that those who do not make the cut-off are listed as zero and those who do are included on the rank

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