Problem trying to identify latest date

[sharky12345]

I'm using this to try to find the latest date with the following formula;

=MAX(IF('121Save'!A2:A1000=D8,'121Save'!C2:C1000))

The criteria applied is a value in column A that matches D8, with the dates being in column C. The result gives me a zero, which isn't correct, but my dates are formatted as text so will that make a difference and if so is there any way around it because I need the dates to remain as text?

 

[AhoyNC]

MAX needs to be numeric, so dates as text will be an issue.
Try this which is an array formula that needs to be entered with CTRL-SHIFT-ENTER.

[TABLE="width: 515"]
<colgroup><col width="515"></colgroup><tbody>[TR]
   [TD="class: xl63, width: 515"]=MAX(IF('121Save'!A2:A1000=D8,('121Save'!C2:C1000)*1))[/TD]
 [/TR]
</tbody>[/TABLE]

 

[sharky12345]

That works - many thanks!

 

[mart37]

=SUMPRODUCT(LARGE((121Save'!A2:A1000=D8)*'121Save'!C2:C1000,1))