finding latest date in table

I have a table with 3 columns, C1, C2, & Date.

Please Login or Register  to view this content.

I would like a formula that would find the C1 with the latest Date for each C2

Please Login or Register  to view this content.

Hi Foxguy,

See the attachment where I have used below formula to achieve the desired result:-
{=OFFSET($A$1,MATCH($B3&MAX(IF($B$2:$B$6=$B3,$C$2:$C$6,"")),$B$2:$B$6&$C$2:$C$6,0),0)}

Find latest date in table.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

Or this:

=MAX(IF($B$2:$B$1000=B2,$C$2:$C$1000))

Comfirmed with ctrl+shift+enter

zbor;
Thanks; I had a feeling it would be an array formula. Now I guess I'll have to learn how to use them.