Value in cell adjacent to max of column

  • Thread starter Thread starter dauclair
  • Start date Start date
D

dauclair

I want to be able to grab a value in a row adjacent to the maximum of
another column. If the maximum value of column C was in row 30, I want
to be able to return the value of cell A30.

Any help would be greatly appreciated.
 
=INDEX($A$1:$A$40,MATCH(MAX($C$1:$C$40),$C$1:$C$40,0)) entered as array formula (hold down Ctrl and Shift while pressing Enter).

Regards
Hans
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MAX() of a range of negative values? 7
Select filled region only in non-adjacent columns 1
Returning Value of Next Non-Blank Cell in Column 2
Macro to Sum Two Adjacent Columns as per Text in previous Column 8
Using text in a cell in a formula 2
nesting functions to compare segments of two columns 1
Formula - Is it possible to... 3
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2

Back
Top