MichaelRed had the right idea with his first response. Add a reference to excel and this becomes much easier.
Call an excel function as such.
prcnt = WorksheetFunction.Percentile(array(), 0.8)
To add all the values to your array use the CSng() function to convert your numbers to singles. You...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.