maxif

Hi All, Long time reader, first time poster here. Basically I am having an issue with reporting some of the data on one of my massive spreadsheets. Ultimately what I am looking to do is have one cell report the maximum time taken to achieve a goal (read from column AJ3), but based on the...

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

<TABLE style="WIDTH: 428pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=568 border=0 x:str><COLGROUP><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 2925" width=80><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" span=4 width=74><COL...

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