I need to find the largest, second largest, etc numbers across a set in a row then have the formula return the columns header (different row, same column).

I know the index function may be best for this, but I am lost getting the function to operate properly here. Thanks for any help you can provide.

-Ryan

I need to find the largest, second largest, etc numbers across a set in a
row then have the formula return the columns header (different row, same
column).

I put header values in A1:J1, and numbers in A2:J14.

I put formulas to show the headers for the largest number of each row in K2:K14; second largest, L2:L14, etc.

The formulas started with this in K2:
=INDEX($A$1:$J$1,1,MATCH(LARGE($A2:$J2,COLUMN()-10),$A2:$J2,0))
Then copy the formula to all of K2:T14.

Modify to conform wiuth your data layout.

Hope this helps getting started.

I need to find the largest, second largest, etc numbers across a set in a
row then have the formula return the columns header (different row, same
column).

I put header values in A1:J1, and numbers in A2:J14.

I put formulas to show the headers for the largest number of each row in K2:K14; second largest, L2:L14, etc.

The formulas started with this in K2:
=INDEX($A$1:$J$1,1,MATCH(LARGE($A2:$J2,COLUMN()-10),$A2:$J2,0))
Then copy the formula to all of K2:T14.

Modify to conform wiuth your data layout.

If there can be a tie in the numbers, the first header gets repeated. Hopefully, this is ok.

Hope this helps getting started.

Hi

Assuming that the row headers are in A1:M1 and the data is is in say A2:M4

=INDEX(A$1:M$1,MATCH(LARGE($A2:$M2,ROW($A1)),$A2:$ M2,0)) and copy down will return the header for the highest in the first row, second highest of the second row, etc.
Or if you want =INDEX(A$1:M$1,MATCH(LARGE(A$2:M$2,ROW($A1)),A$2:M $2,0)) and copy down, will give you the header for the highest, second, etc for that row.

Is this something that you could work with!

Quote:

Originally Posted by I need to find the largest, second largest, etc numbers across a set in a row then have the formula return the columns header (different row, same column). I know the index function may be best for this, but I am lost getting the function to operate properly here. Thanks for any help you can provide. -Ryan

On Tue, 19 Mar 2013 17:50:30 -0700 (PDT), zvkmpw wrote:

=INDEX($A$1:$J$1,1,MATCH(LARGE($A2:$J2,COLUMN()-10),$A2:$J2,0))

Not tested but I think you would get the same result, and not have it be dependent on the intial column, by using:

COLUMNS($A:A)