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