Return the max date looking at multiple criteria

Marlei

Trying to add the most recent training completion date (column is date/non-restricted) using mulitple criteria, to include: email address, training type ("refresher", or "intensive") and status ("attended") to a designated column (date/non-restricted) on another sheet.

The formulas below are pulling the same date into each column on the metric sheet, so it appears that the formula's are not considering the training type. Idea's on how to correct?

=MAX(COLLECT({2_All Training Attendance Training Date}, {2_All Training Attendance Email Address}, [E-mail Address]@row), {2_All Training Attendance Training Type}, "Intensive", {2_All Training Attendance Status}, "Attended")

=MAX(COLLECT({2_All Training Attendance Training Date}, {2_All Training Attendance Email Address}, [E-mail Address]@row), {2_All Training Attendance Training Type}, "Refresher", {2_All Training Attendance Status}, "Attended")

Marlei

Goodness… I figured it out. I forgot to add the equals (=) sign into my formula on each criteria. Oops!

Corrected formula is below:

=MAX(COLLECT({2_All Training Attendance Training Date}, {2_All Training Attendance Training Type}, ="Refresher", {2_All Training Attendance Status}, ="Attended", {2_All Training Attendance Email Address}, =[E-mail Address]@row))

Marlei

Goodness… I figured it out. I forgot to add the equals (=) sign into my formula on each criteria. Oops!

Corrected formula is below:

=MAX(COLLECT({2_All Training Attendance Training Date}, {2_All Training Attendance Training Type}, ="Refresher", {2_All Training Attendance Status}, ="Attended", {2_All Training Attendance Email Address}, =[E-mail Address]@row))