Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array function
Hi,
If I have an array of number, for instance grades(25,10,30,22), is there a function that I could use to tell me which position of the array list contains the smallest value? ie. in this case, it will return 1 as 10 is the smallest value and its position in the array "grades" is 1. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array function
With your numbers entered in A1:A4, the formula =MATCH(MIN(A1:A4),A1:A4,0)
returns 2 as the min value (10) is in the second (not first) position Likewise, =MATCH(LARGE(A1:A4,3),A1:A4,0) returns 4 since the third largest value (here 22) is in position 4. best wsihes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array function
S wrote:
Hi, If I have an array of number, for instance grades(25,10,30,22), is there a function that I could use to tell me which position of the array list contains the smallest value? ie. in this case, it will return 1 as 10 is the smallest value and its position in the array "grades" is 1. Thanks. Since this is in the programming group, and because you referred to 10 as being in the 1 position in the array, I'll assume that grades is a 0-based array. positionNumber=Application.Match(Application.Min(g rades), grades, 0) - 1 Alan Beban |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array function
Thanks a lot. This is exactly what I am looking for.
"Alan Beban" wrote: S wrote: Hi, If I have an array of number, for instance grades(25,10,30,22), is there a function that I could use to tell me which position of the array list contains the smallest value? ie. in this case, it will return 1 as 10 is the smallest value and its position in the array "grades" is 1. Thanks. Since this is in the programming group, and because you referred to 10 as being in the 1 position in the array, I'll assume that grades is a 0-based array. positionNumber=Application.Match(Application.Min(g rades), grades, 0) - 1 Alan Beban |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What function or array to use? help please :o) | Excel Worksheet Functions | |||
OR function in array-entered IF function | Excel Worksheet Functions | |||
Redimming an array dynamically assigned from range (how to redim first dimension of a 2-D array? /or/ reverse the original array order) | Excel Programming | |||
Help for Array function | Excel Worksheet Functions | |||
#DIV/0! in the array function | Excel Worksheet Functions |