Hi all,

Quick Excel question..

Got two columns of data. Want to search the right hand column for it’s max value, and present. That’s easy, just use the MAX function. I then also want to present the value to the left of the maximum value of the right column. How do I do that?

Ta, Duane.

Index and match: http://www.randomwok.com/excel/how-to-use-index-match/

You use match to find the result of the max function in the right hand column, then index to find that row in the left hand column.

Be aware that if the max value has duplicates that^ won’t necessarily return what you’re after.

Thanks, still struggling though, absolute Excel luddite :/

Not really sure I understand but if your column of values is in col B, then try this in col A: =IF(B2=MAX(B:B),B2,””) – Put in A2 first then drag down.

Edit – you may want to change the last B2 reference in the formula to refer to another column? e.g change it to C2 to show the value in col c.