CODEWITHSUNDEEP
excelexcel-formula
Henry P.
Henry P.

Reputation: 155

Return the position (column) of the maximum value

Hello I've been trying to figure out how to return position (column number) of the maximum value of a list (row of numbers).

Please see attached as an example. I want to return 'Rate 1' since the max is 52,204 -- I know I can use VLOOKUP and also INDEX and MATCH but I don't think they work in this example and I don't want to switch the rows/columns.

Please point me in the right direction and I will keep at it.

Thanks

Example

Upvotes: 0

Views: 42

Answers (1)

SJR
SJR

Reputation: 23081

Try this

=index(a1:c1,match(max(a2:c2),a2:c2,0))

adjusting ranges to suit.

Find the relative position of the max in row 2 (=1) and return the corresponding element in row 1 (=Rate1).

Upvotes: 1

Related Questions