Returning Header Linked to Row Max (1 Viewer)

[Therat]

What is the formula I need to use to return a text header that is in the same column of the cell which has the max value within each row of my spreadsheet?

My spreadsheet has 1,000 plus rows and over 60 columns so I need a formula.

See the attachment below for the example.


Thanks in advance.

 

[shades]

Can't see your example. But suppose that you have headings in row 2 (D:J), and data begins in row 3 (D:J), then put this formula in a cell on row 3.

=INDEX($D$2:$J$2,1,MATCH(MAX($D3:$J3),$D3:$J3,FALSE))

Copy down your 1,000 rows.

Adjust ranges to suit.
________
NEVADA MEDICAL MARIJUANA DISPENSARY

 

[Therat]

It worked!

Shades,

Thanks for fast and accurate response!