Excel help please..

Home Forum Chat Forum Excel help please..

Viewing 5 posts - 1 through 5 (of 5 total)
  • Excel help please..
  • Duane…
    Member

    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.

    Premier Icon miketually
    Subscriber

    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.

    Rob Hilton
    Member

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

    Duane…
    Member

    Thanks, still struggling though, absolute Excel luddite :/

    tinribz
    Member

    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.

Viewing 5 posts - 1 through 5 (of 5 total)

The topic ‘Excel help please..’ is closed to new replies.