| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding an item in a list & returning a specific value | Excel Worksheet Functions | |||
| Getting the position of an item in a pivot table | Excel Programming | |||
| Getting a the position of a single item in an array | Excel Programming | |||
| finding lowest priced item in a list | Excel Discussion (Misc queries) | |||
| UDF to give position of item If list was Alpabetic | Excel Programming | |||
Threaded Mode
