All articles with 'Rankifs' Tag
{ 9 Comments }
Conditional Rank, the easy way [quick tip]
Published on Oct 20, 2017 in Pivot Tables & Charts
![Conditional Rank, the easy way [quick tip]](https://chandoo.org/wp/wp-content/uploads/2017/10/group-ranking-pivot-tables-excel.png)
Yesterday, my mate from across the ditch, Hui posted about conditional rank formula (RANKIFS) using awesome SUMPRODUCT
Of course, not everyone can whip up a sumproduct formula like that. On a scale of One to Hui of Excel awesomeness, you would need to be at least an H to write sumproduct or countifs formulas shown in that post. So does it mean, you can’t conditional rank if you don’t know your X from L?
Don’t worry. We got you covered. You can still get your conditional ranks, without inception level array formulas. Simple, use pivot tables instead.
Continue »![Formula Forensics 043: Rankifs or Conditional Rank](https://chandoo.org/wp/wp-content/uploads/2017/10/Rankif0000.png)
Learn how to develop a Conditional Rank or Rankifs formula in Excel
Continue »