Need one miracle
 

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

--
John2
-----------------------------------------------------------------------
John21's Profile: http://www.excelforum.com/member.php...fo&userid=3698
View this thread: http://www.excelforum.com/showthread.php?threadid=57379

Need one miracle
 

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

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

--
John2
-----------------------------------------------------------------------
John21's Profile: http://www.excelforum.com/member.php...fo&userid=3698
View this thread: http://www.excelforum.com/showthread.php?threadid=57379

Need one miracle
 

I doubt anyone can figure out what you want.

--
Regards,
Tom Ogilvy


"John21" wrote in
message ...

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

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


--
John21
------------------------------------------------------------------------
John21's Profile:
http://www.excelforum.com/member.php...o&userid=36983
View this thread: http://www.excelforum.com/showthread...hreadid=573792