comparing cell values to determine which is highest, then returning the name assocaited

Hi All,

I'm new to the forum, mainly because I have searched high and low across the interwebs and nothing is coming close to the problem I'm trying to work out

This is the skinny:

In essence, I have a ratio between different items (apples oranges bananas etc in the attached example to keep it simple) with a ratio set against them for each month of the year going back. This number is based upon 1000 being the benchmark. Each month it can either be above or below that number depending on its strength.

What I’m looking for is the equation (I’m guessing some kind of complicated index formula) whereby it spits out which is the strongest and weakest fruit looking back on both 1, 4, and 10 years, for its particular month.

Capture.PNG