Forum Discussion

Dale Lori's avatar
Dale Lori
Copper Contributor
Oct 03, 2018

Stopping a MAX function after one result.

I'm using a MAX function with 2 ranges =MAX(IF(ActDName=$A3,ActDDate)).    Which I'm using to bring back the most recent date where a development plan is in place.  In essence, it looks up a person...
Excel
Formulas and Functions
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Oct 03, 2018

    Your Excel version doesn't support MAXIFS().

    Use AGGREGATE() instead.

    =IF(COUNTIFS(ActDName,A3,ActionDevelopment!$F$2:$F$14,"Yes"),"",AGGREGATE(14,6,ActionDevelopment!$D$2:$D$14/(ActDName=A3),1))

     

Resources