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 -...
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...
<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...
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 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.