Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dim Arr(5) as integer
Arr(2) = 99 Arr(3) = 101 How do I then find out what the maximum value is, and what position itıs at in this type of array * i.e. for the above, the maximum is 101, at position 3. Iıve had success with Application.WorksheetFunction.Large(Arr, 1) But still canıt get the position of that number. Iım attempting this with an array that is 1000 in size if thatıs going to be a problem ... Thanks, Brad.) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Array formula to Identify Leading Zeros. | Excel Discussion (Misc queries) | |||
How do identify if a number is NOT in an array? | Excel Discussion (Misc queries) | |||
Finding Location of Maximum Value in 2D Array | Excel Discussion (Misc queries) | |||
Finding Location of Maximum Value in 2D Array | Excel Worksheet Functions | |||
Identify occurence in "array" which meets condition(s) | Excel Discussion (Misc queries) |