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?