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