Index/Match of Max If

[Noz2k]

Essentially I have some data that is like the below, in a sheet called 'Data':

[TABLE="width: 500"]
<tbody>[TR]
[TD]C1[/TD]
[TD]01/01/2018[/TD]
[TD]TypeA[/TD]
[/TR]
[TR]
[TD]C2[/TD]
[TD]04/01/2018[/TD]
[TD]TypeB[/TD]
[/TR]
[TR]
[TD]C3[/TD]
[TD]23/12/2017[/TD]
[TD]TypeA[/TD]
[/TR]
[TR]
[TD]C2[/TD]
[TD]12/01/2018[/TD]
[TD]TypeC[/TD]
[/TR]
[TR]
[TD]C1[/TD]
[TD]19/12/2017[/TD]
[TD]TypeC[/TD]
[/TR]
</tbody>[/TABLE]


What I want to return in a new sheet for each ID, is the latest date, and the corresponding Type, so the end result would look like below

[TABLE="width: 500"]
<tbody>[TR]
[TD]C1[/TD]
[TD]01/01/2018[/TD]
[TD]TypeA[/TD]
[/TR]
[TR]
[TD]C2[/TD]
[TD]12/01/2018[/TD]
[TD]TypeC[/TD]
[/TR]
[TR]
[TD]C3[/TD]
[TD]23/12/2017[/TD]
[TD]TypeA[/TD]
[/TR]
</tbody>[/TABLE]


I can get the latest date using the below formula, but do not not how to get the value in the corresponding column C for that row

{=MAX(IF('Data'!A:A=A2,'Data'!B:B))}

 

[Special-K99]

=INDEX(Data!C:C,MATCH(1,(Sheet1!B1=DataB:B)*(Sheet1!A1=Data!A:A),0),1)
Array formula, use Ctrl-Shift-Enter

where Sheet1 is your results sheet.

 

[Noz2k]

Awesome, meets my requirements thank you.

and helped me work out how to do it if I didn't already have the max data in column B.

Thanks,