Hi there
I’m exploring Powerpivot DAX formulae and its ability to do the equivalent of array formulae in Excel using dynamic/cell based criteria.
I’d like to do the equivalent of
1. AVERAGEIFS
2. MAXIFs.
I’ve scanned through previous posts, but cant seem to find the syntax that...
Hello. I hope somebody can help me on this one. I have been trying this for a day or so and looked up on google and this site to no luck.
I want to be able to run a VLOOKUP (or alternative) after creating a subset through MAXIF. Here is an example with some data. I can use the MAXIF function...
So I have a sheet (sheet1) with data setup as such:
<tbody>
01/01
01/02
01/03
01/04
01/05
01/06
01/07
100
200
300
400
600
450
50
</tbody>
On sheet2, I would like to use a formula that looks at this data range and and show me that from 01/01 - 01/07, 600 was the MAX value...
Hello,
I am creating a system where I need Google Docs version of Excel to find the maximum based on two criteria, tell me the address of the cell the formula found this number and then convert to the column header. Ideally, I'd be able to see that a student scored a 100 on learning goal on a...
I would like to write a formula that looks at the last month with a percent value greater than zero, then return the percent value in a specific cell. In the example below I want to display 85.0% in the cell. It should update each time data is entered for the following month.
Here is the...
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.