The RANK function should really continue to operate high-quality in more mature worksheets. In case you are updating an older worksheet, you could optionally switch RANK with RANK.EQ and obtain precisely the same habits and outcomes. And further more complicating points: engines like google have additional equipment Mastering features as https://96.126.114.149