Reporting maxima of dataset?

[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

 

[J.E. McGimpsey]

One way:

=INDEX(X:X,MATCH(MAX(Y:Y),Y:Y,FALSE))

 

[immanuel]

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.

 

[marsupilami]

Thank you! That worked nicely