Need some help

[John21]

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.

 

[Biff]

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

 

[Biff]

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