Excel formula help

Hi All, A1 = Name A2 = Value A3 = Value A4 = Name The highest value must pull through to A7 and the name linked to that value must pull through to A6 Thus if A1 = John, A2 = 10, A3 = 17, A4 = S...