View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Stevens Paul Stevens is offline
external usenet poster
 
Posts: 15
Default Index of Minimum value in array

In a two dimensional array I want to find the position of
the minimum value in the first dimension and return the
value from the equivalent position in the second dimension.

My array is a VBA variable, not a range reference, and
it's values are not in any order. Ubound is several
thousand so I don't want to loop and for other reasons do
not want to sort. If necessary my two dim array could be
reconstructed as two complimentary single dim arrays.

I've been messing around with various worksheet functions
(incl .Min), but I'm fumbling!

TIA for any help,
Paul