ExcelBanter - to get its k-value from percentile and array

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - to get its k-value from percentile and array (https://www.excelbanter.com/excel-programming/385870-get-its-k-value-percentile-array.html)

Peter

to get its k-value from percentile and array

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

Peter

to get its k-value from percentile and array

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

Tom Ogilvy

to get its k-value from percentile and array

I think you meant:

PERCENTRANK

--
Regards,
Tom Ogilvy

"Peter" wrote:

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

All times are GMT +1. The time now is 12:17 AM.