decile function

[an01digital]

I am looking for help around creating a custom function for calculate
the decile rank.

Any help will be appreciated.

Thanks

 

[Bernard Liengme]

Why reinvent the wheel when there is a worksheetfunction Percentile?
best wishes