This may be performed by incorporating the next correction element to the value returned by RANK. This correction element is appropriate the two for the case where rank is computed in descending buy (purchase = 0 or omitted) or ascending get (purchase = nonzero benefit). I requested Zhukova her thoughts https://www.aberdeendycelp.com