Formula that Assesses student for best figure/grade and addes additional information

Hi Folks,
Below are a series of columns with data. (column 7 is blank)
The idea is to assess the speed figures for each student and then, in column 8, to produce a line of data that indicates the best figure earned by each student, the distance at which it was earned, the location, the ground condition and the date on which that figure was earned.

Column1 Column2 Column3 Column4 Column5 Column6 Column7 Column8
Name Date Distance Location Ground Speed Fig Best Performance Analysis
John 6/2/2014 100m Indoor Fast 100 Best Performance was 100 earned at 100m on a Fast Indoor track on 6/2/2014
John 5/5/2014 200m Outdoor Wet 87 Best Performance was 100 earned at 100m on a Fast Indoor track on 6/2/2014
John 3/10/2014 100m Outdoor Sloppy 78 Best Performance was 100 earned at 100m on a Fast Indoor track on 6/2/2014
John 2/15/2014 400m Indoor Fast 98 Best Performance was 100 earned at 100m on a Fast Indoor track on 6/2/2014
Jim 5/5/2014 100m Outdoor Fast 102 Best Performance was 102 earned at 100m on a Fast Outdoor track on 5/5/2014
Jim 4/6/2014 200m Outdoor Wet 98 Best Performance was 102 earned at 100m on a Fast Outdoor track on 5/5/2014
Jim 3/8/2014 100m Indoor Fair 88 Best Performance was 102 earned at 100m on a Fast Outdoor track on 5/5/2014
Jim 2/6/2014 400m Indoor Fast 85 Best Performance was 102 earned at 100m on a Fast Outdoor track on 5/5/2014
Jack 6/1/2014 100m Indoor Fast 95 Best Performance was 103 earned at 200m on a Fast Outdoor track on 5/15/2014
Jack 5/15/2014 200m Outdoor Fast 103 Best Performance was 103 earned at 200m on a Fast Outdoor track on 5/15/2014
Jack 4/8/2014 100m Outdoor Wet 102 Best Performance was 103 earned at 200m on a Fast Outdoor track on 5/15/2014
Jack 3/19/2014 200m Indoor Fast 94 Best Performance was 103 earned at 200m on a Fast Outdoor track on 5/15/2014

Is there a formula that will help me achieve this?
I have been shown a formula to identify the highest figure - however, would like to be able to see the data appear like it does on column 8.
Any positive assistance will be greatly appreciated.
Thank You