rank if ascending order

  1. G

    Using Rank formula with non consecutive rows

    Hello, I'm trying to use the rank formula to retrieve the three largest values. However, the data that needs to be ranked is entered with a row in between each value. I can't figure out how the rank formula should be written (if even possible) to recognize and rank values on non-consecutive...
  2. D

    Rank IF Ascending Order

    Hello, I'm trying to rank in ascending order the top 20 lowest margin generating items by week. I'm stumped on what sort of formula to use for this. I will have a data tab consisting of historical data from previous weeks. I would like to be able to call out the top 20 margin loss drivers by...

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