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.

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

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(grades), grades, 0) - 1

Alan Beban

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(grades), grades, 0) - 1
>
> Alan Beban
>