Finding the position of the nth item in a list
I have a feeling I should know this.
Let's say I have a list of 10 numbers in random order.
7
10
3
5
1
9
4
2
8
6
I would like to know the position of the smallest number.
Is there a function where I can give it SMALL(range,1) and have it tell me it's in the 5th position?
|