5 Replies Latest reply on Jan 7, 2013 2:14 PM by Shawn Wallwork

    How to return value at a corresponding maximum value?

    Craig Perrett

      I have an Excel file with multiple rows of hourly data.  Lets assume that column one is "Date/Time", column two is "Sales" and column three is "Profit Ratio".  How would I create a formula to return the "Profit Ratio" at the maximum "Sales" value?