This may be accomplished by introducing the next correction issue to the value returned by RANK. This correction variable is appropriate equally for the situation exactly where rank is computed in descending buy (get = 0 or omitted) or ascending get (purchase = nonzero worth). Britannica Dictionary definition of RANK https://97.107.137.110