Forum Discussion

Thomas Bryant's avatar
Thomas Bryant
Copper Contributor
Aug 22, 2017

Reverse Ranking

Does anyone know how to make this equation count from lowest to highest =RANK(B3,$B$3:$B$23,0) - ( COUNTIF($B$3:$B$23, ">"&B3)- SUMPRODUCT(($B$3:$B$23>B3)*1/COUNTIF($B$3:$B$23,$B$3:$B$23)) )
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 24, 2017

Thomas, it's here

=RANK(B3,$B$3:$B$23,1) -
   (
      COUNTIF($B$3:$B$23, "<"&B3)-
      SUMPRODUCT(($B$3:$B$23<B3)*1/COUNTIF($B$3:$B$23,$B$3:$B$23))
   )

and attached