Analysing 3 columns of different data

[Nor]

I need help to compile a formula that can evaluate the best performance factor as seen below. Which of these 4 examples performed the best, considering that heaver weight is as disadvantage but should not exclude from being the best performer. The actual list is much longer. The reasoning for this result is to show up the horse rider that performed the best for their weight over the time they achieved at the calculated speed. These results are recovered from the endurance time keeping system.
thank you,

A B C
weight time speed
88.9 05:30:30 20.0
79.4 05:19:30 22.1
80.1 04:59:45 27.0
45.9 04:39:00 25.0

[dilipandey]

Hi Nor,


welcome to the forum.
Please revise the thread title to reflect the query you are asking.. see forum rules:-

http://www.excelforum.com/forum-rule...rum-rules.html


Regards,
DILIPandey
<click on below * if this helps>