Icon
 

Excel RANK function and rank by groups using SUMPRODUCT