finding kth smallest value in an array
Emin
Where is this array? What program? XL has a worksheet function called
RANK, you can probably use this
--
HTH
Nick Hodge
Microsoft MVP - [Excel]
Southampton, England
Quote:
> hi,
> i have an array with date values.i want to sort them and find for example
> 3.smallest date value in this array and then go and find the 4.smallest
> value...