I need location of MIN / MAX in an array

J

John Gilchrist

I have an array of footage vs. thickness
Column A:1 --> A:10000 = footage
Column B:1 --> B:10000 = thickness

I use the MAX function to calculated the maximum thickness

I need to find the footage at which the maximum thickness occurs

Can I do this with a function, or do I need to use VB code to process the
array and find the location of the max thickness??

Thank you
John
 
B

Bob Phillips

=INDEX(B1:B10000,MATCH(MAX(A1:A10000),A1:A10000,0))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
J

John Gilchrist

Thank you both for your help - I will try this & let you know
Thanks again,
John
 
J

John Gilchrist

Thank you all for your help - this index command solved my problem
Thanks again,
John
 
Top