Hi folks,
I got the answer in-house. The Excel function is percentrange.
Thanks anyway.
PeterK

"Peter" wrote:

Hi folks,
Is it a way to get its k-value from percentile and array. Thanks.
PeterK