Reporting maxima of dataset?

  • Thread starter Thread starter marsupilami
  • Start date Start date
M

marsupilami

How can I get excel to find the maximum value of a graph and report th
x-axis value? I'm looking for a function I can use on the data column
x and y. I.e. what is the numerical value of the cell in column x tha
corresponds to the maximum value of column y.

Any suggestions
 
If your data for y are in B2:B10 and your data for x are in A2:A10, then you
can use the following to find the value of x where y is the maximum:

=INDEX(A2:A10,MATCH(MAX(B2:B10),B2:B10,0))

Note that this will only find the first x value for which y is the max.

/i.
 
Back
Top