Earliest and Latest Dates from a list of names?

Please find attached excel file. I am stumped as to what formula I should try in order to achieve as in the examples?

I've tried MAX/MIN formulas and sometimes using IF formula, but with no success?

Any ideas?

Cheers.

For the minimum, try...

H2, confirmed with CONTROL+SHIFT+ENTER, and copied down:

=MIN(IF($B$2:$B$21=F2,$C$2:$C$21))

For the maximum, change MIN to MAX.

Hope this helps!