Multiple Criteria --get unique value

Hello! Just wondering if anyone could help with the file attached.
Need a formula in H which yields the results shown i.e., For every Value in B and C in combo is repeated together then only grab the Value in F corresponding to the greatest date for the combo.

Much appreciated.