Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to find a result in an array in the same row as a minimum resu | Excel Discussion (Misc queries) | |||
Minimum array formula. | Excel Worksheet Functions | |||
Array Formula Minimum Excluding Text | Excel Discussion (Misc queries) | |||
Minimum Distance Calculation using Array and Geographical Coordinates | Excel Discussion (Misc queries) | |||
Finding minimum value across selected rows of an array | Excel Worksheet Functions |