Need one miracle

[John21]

Hi,
I’m trying to find a way in wish I can compare some values in a row an
return the title of the column and the amount. I need to retrieve th
first three mayor values in different cells. For example:

_ Number _ model _ amount ____ years ___food
John ___10 ___ Lono __45 __20
___Banana
Angel __35 _ _Part ___18 _ __50
_____Pizza
Jose ___20 __ Long __30 __17
_Nothing

Return: 45 amount, 20 years, 10 Number
50 years, 35 Number, 18 amount

and I need the numbers and the titles in diferrent cells to late
create links to this value

 

[John21]

Something like this can't be done??????????:

=OFFSET(Max(B7:E7),-1,0,1,1

 

[Tom Ogilvy]

I doubt anyone can figure out what you want.