I need location of MIN / MAX in an array

  • Thread starter Thread starter John Gilchrist
  • Start date Start date
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
 
=INDEX(B1:B10000,MATCH(MAX(A1:A10000),A1:A10000,0))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Thank you all for your help - this index command solved my problem
Thanks again,
John
 
Back
Top