如何用excel算出一列數中大小排80%的數字

請問有什麽方法，可以用excel算出一列隨機數中，第80%大的那個數字，最好不用排序，sort，之類的方式。

謝謝。

所有跟帖： 

• 回複：如何用excel算出一列數中大小排80%的數字 -nanochip- ♂ (91 bytes) () 08/19/2009 postreply 10:19:04

• thanks, but that is a series of random number -cloudate- ♂ (0 bytes) () 08/19/2009 postreply 13:25:20

• 回複：thanks, but that is a series of random number -nanochip- ♂ (227 bytes) () 08/20/2009 postreply 15:32:06

• percentile -haha2000- ♂ (44 bytes) () 08/20/2009 postreply 06:01:58

• percentile(array,0.8) -康MM- ♀ (0 bytes) () 08/20/2009 postreply 06:03:36

• thanks a lot, I also find a different approach using function pe -cloudate- ♂ (0 bytes) () 08/21/2009 postreply 00:21:06

• thanks I also find a different approach using percentrank() -cloudate- ♂ (0 bytes) () 08/21/2009 postreply 00:21:55