I am stuck on something that I though was simple, I am trying to find the row of the lowest value in an excel array. In the excel sheet attached I would like to find the lowest number from B25:B70. I would then like to paste the value and associated L and C values into K1(value),L1(L-value),M1(C-value). In the attached example, my minimum value is 1500, my L-value = L: 5703 IND RIV 230 5705 STANTONE 230 1, and my C-value is C: 5703 IND RIV 230 5716 STANTONW 230 1. I found the code below on-line, but I don't know how to use a function in my subsystem or if it is close to what I want, but it's the closes I have found.
Thanks for your help,
Function MinAddress(The_Range) ' Sets variable equal to minimum value in the input range. MinNum = Application.Min(The_Range) ' Loop to check each cell in the input range to see if equals the ' min variable. For Each cell In The_Range If cell = MinNum Then ' If the cell value equals the max variable it ' returns the address to the function and exits the loop MinAddress = cell.Address Exit For End If Next cell End Function
15.5 KB Views: 51