Hello all. I found a thread that discussed the above but not in VBA. The link is :
https://www.pcreview.co.uk/forums/algorithm-computing-excel-percentrank-t946312.html
This topic explains the algorithm in C# and others. Is it possible for someone to ... translate in VBA. I need this function in Access and using Excel by code is not an option.
I have found a couple of functions but they do not deal with duplicate values in the passing array. The code above deals with "simple linear
interpolation between the points in the range bracketting your second
argument value." I am not sure what this means but it may be the answer to the problem.
Thanks you so much.
D Lamarche
https://www.pcreview.co.uk/forums/algorithm-computing-excel-percentrank-t946312.html
This topic explains the algorithm in C# and others. Is it possible for someone to ... translate in VBA. I need this function in Access and using Excel by code is not an option.
I have found a couple of functions but they do not deal with duplicate values in the passing array. The code above deals with "simple linear
interpolation between the points in the range bracketting your second
argument value." I am not sure what this means but it may be the answer to the problem.
Thanks you so much.
D Lamarche