# maxif

1. ### VLOOKUP and MAX IF. Is this possible?

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...
2. ### MAX value found based on date range

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...
3. ### Excel find maximum in range based on two criteria, return address and show value based on address

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...
4. ### What IF's

<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...
5. ### MaxIf Function

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

### Which adblocker are you using?

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

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