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