This can be completed by incorporating the subsequent correction factor to the value returned by RANK. This correction factor is appropriate both for the case where rank is computed in descending order (order = 0 or omitted) or ascending order (order = nonzero value). Trusted by enterprise builders around the https://www.imdb.com/title/tt30110854/?ref_=wl_t_1