I am bad at this, please help - MAXIF function?

[hver1075]

Hi,

Trying to get the "Last Completed" formulas to generate correctly in column I. I want the formula to find the most recent date (from column E) and automatically update. So for cell I3, I want it to put the most recent date (from Column E) when it's corresponding cell from column A says "Adult Fiction Books." For J3, I want it to put the most recent date (from column E) when it's corresponding cell from column A says "Adult Mystery Books" etc.

I'm pretty unfamiliar with multiple criteria formulas and came up with:
=MAX(IF($A$3:$A$100=I2,$E$3:$E$1000=DATEVALUE(mm/dd/yyyy))) for cell I3. But, unsurprisingly, it doesn't work.

Thanks for any help!

 

[John Jairo V]

Hi @hver1075:

Try (CSE : Ctrl + Shift + Enter)
=MAX(IF($A$3:$A$100=I2,$E$3:$E$100))

or (No CSE)
=MAX(INDEX(($A$3:$A$100=I2)*$E$3:$E$100,))

And later, put the format (if necessary) of the cells into dates.

Blessings!

 

[kuldeepjainesl]

A very detail tutorial on achieving this is available at
http://blog.contextures.com/archives/2013/11/19/using-max-if-with-multiple-criteria/

Hope this help

 

[hver1075]

Thank you both very much!