Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The Miracle Of Discipline | Excel Worksheet Functions |