Percentile - data in arrays

B

BHARATH RAJAMANI

Hi

I have 1mio unsorted ccy values in an array. I need to find the 99.99th
percentile of these values, without writing them to a .xls and using the
worksheetfunction.percentile function.

How to?

TIA!!

Rgds,
BR
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Percentile - Data in arrays 0
Percentile --> how to? 3
Ranking without skipping ranks and percentile 3
using percentile in an array formula 1
Embedding excel formula in MS Query that will be evaluated in excelnot in the SQL server 0
percentile - data in 2 different ranges 4
Paste Array to .xls : All at once 6
Percentile 1

Top