- Excel help please..
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.Posted 4 years agomiketuallySubscriber
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.Posted 4 years agotinribzMember
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.Posted 4 years ago
The topic ‘Excel help please..’ is closed to new replies.