Function to pick Peak or Min from table of values in Excel

  • Thread starter Thread starter borourke
  • Start date Start date
B

borourke

Is there a simple way to use a function to match the
maximum value to a position in Excel (or better yet
derivitives).

Example
Wavelength 400 500 600 700 800
%T 5.0 4.9 4.6 5.9 7.0

I would like to find the max %T's wavelength (800)
and the min %T wavelength (600)

Thanks
 
Is there a simple way to use a function to match the
maximum value to a position in Excel (or better yet
derivitives).

Example
Wavelength 400 500 600 700 800
%T 5.0 4.9 4.6 5.9 7.0

I would like to find the max %T's wavelength (800)
and the min %T wavelength (600)

Thanks
Click to expand...

With Wavelength in row 1 (A1:F1 in your example):

MaxT's wavelength: =OFFSET($A$1,,MATCH(MAX(T),T,0))
MinT's wavelength: =OFFSET($A$1,,MATCH(MIN(T),T,0))


--ron
 
Assuming your data is in B1:F2, use this for max:

=INDEX(B1:F1,MATCH(MAX(B2:F2),B2:F2,0))

And for the min, just change the word "max" with "min".

HTH
Jason
Atlanta, GA
 
Back
Top