Is there any way to use a function like this:
=OFFSET(MAX(A2:E2),1,2,1,1)

the goal is to find the first 3 bigger values in a row and return them
with the title of the column.


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

From Excel help on Offset:

OFFSET(reference,rows,cols,height,width)

Reference is the reference from which you want to base the offset.
Reference must refer to a cell or range of adjacent cells; otherwise, OFFSET
returns the #VALUE! error value.

-------------------

The first argument must be a cell reference, not a value:

MAX(A2:E2)

Biff

"John21" wrote in
message ...

Is there any way to use a function like this:
=OFFSET(MAX(A2:E2),1,2,1,1)

the goal is to find the first 3 bigger values in a row and return them
with the title of the column.


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