View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] ilovekids123@gmail.com is offline
external usenet poster
 
Posts: 4
Default 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?