View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John21[_11_] John21[_11_] is offline
external usenet poster
 
Posts: 1
Default 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