On Monday, September 18, 2017 at 10:00:30 PM UTC-7, GS wrote:
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?

Have a look at the INDEX() function...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Doesn't INDEX do the opposite, Garry? I give it a position, and it returns a value.