| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
offset function
I am trying to offset the value of the 'n'th smallest number in an array that is NOT in order... is there any way I can do this? I have tried =offset(small(a1:a5,1),0,1,1,1), but it returns an error. If you can shed any light on this problem I would be much abliged. Brad CANADA -- hidden_stairway ------------------------------------------------------------------------ hidden_stairway's Profile: http://www.excelforum.com/member.php...o&userid=24459 View this thread: http://www.excelforum.com/showthread...hreadid=380550 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| large function result as reference for offset function | Excel Discussion (Misc queries) | |||
| XL2002 - OFFSET function and LARGE function | Excel Worksheet Functions | |||
| using offset function | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Offset function | Excel Programming | |||
![hidden_stairway[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
