Forum Discussion
Issues with Excel Ranking Formulas (Skipped or Duplicate Rank Numbers)
Hi, 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...
I'm not sure if I understood it correctly, here's an example in the file.
Hope this will help you.