Forum Discussion

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)) )

Diamond Contributor

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