All articles with 'Rankifs' Tag
{ 8 Comments }
Conditional Rank, the easy way [quick tip]
Published on Oct 20, 2017 in Pivot Tables & Charts
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 »Learn how to develop a Conditional Rank or Rankifs formula in Excel
Continue »