dynamic ranking

  1. D

    Adding criteria to dynamic rank formula

    Hi, I've found a dynamic rank formula on the web that updates the rank as I filter, but I need to add another level, so it's ranking by country. I don't really understand how the formula works, so I'm unable to edit this myself. This is the formula that I am using -...
  2. A

    Dynamic VBA ranking

    Hey Guys I am new at MrExcel and hope you could help me out :) I have a spreadsheet where I in VBA determines a range, design, etc. to update and change a graph given the input selected in the tab. As it can be seen in this example from the screenshot the columns are simply listed based on the...
  3. J

    How can I use Rank.Eq, Countifs, and Offset to Rank a Filtered Table

    <tbody> Language Criteria1: Wait time(min) Criteria2: Success Rate Criteria3: Volume EN 30.5 61.5% 200000 EN 70.0 75.3% 4765 SP 10.0 57.34% 8000 SP 47.0 49.6% 2000 SP 47.0 55.81% 310000 </tbody> I've been all over this forum and google trying to find out how...
  4. Rickmaurinus

    Dynamically Rank Stores - Cubeset, CubeRankedMember (works 99,9%, who helps me with the 0,01%)?

    Dear Excel gurus, Recently I've build a dashboard to show the performance of our stores. Data has been put in the data model, and I made measures in power pivot (DAX) to measure performance. To dynamically rank my stores in Excel I've used the CubeSet and CubeRankedMember functions in excel...

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