finding kth smallest value in an array 
Author Message
 finding kth smallest value in an array

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...


Sun, 20 Oct 2002 03:00:00 GMT  
 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...



Sun, 20 Oct 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Getting kth value from a set

2. Smallest value in an array

3. finding the position of a value in an array

4. problem finding highest values in an array

5. function to find highest value of an array?

6. Convert array of value type to array of reference type

7. Finding the number value of a hex value

8. Small problem with arrays

9. Small problem with arrays

10. Choosing the smallest values of variables.

11. redim 1st dimension of 2 dimensional array to be smaller

12. Choosing the smallest values of variables.

 

 
Powered by phpBB® Forum Software