Issues with Excel Ranking Formulas (Skipped or Duplicate Rank Numbers)

Copper Contributor

I've used the RANK.EQ combined with COUNTIF formula, but it continues to skip the rank numbers. Additionally, attempting the SUMPRODUCT formula with COUNTIF also led to skipped rank numbers. How can I resolve this issue, or is there an alternative formula to circumvent this problem?
In column C and D highlighted in red are the ones that are wrong. (File attached)

1 Reply


I'm not sure if I understood it correctly, here's an example in the file.


Hope this will help you.