Formula to RANK groups of values.

Hi,

Use this formula :

=IF( A2="",
     "",
     IF( AVERAGEIFS($F$2:$F$3000,$A$2:$A$3000,$A2,$B$2:$B$3000,$B2,$C$2:$C$3000,$C2)=$F2,
         0,
         COUNTIFS($A$2:$A$3000,$A2,$B$2:$B$3000,$B2,$C$2:$C$3000,$C2,$F$2:$F$3000,">"&F2)+1
     )
)

Regards

You are welcome Hammer, and many thanks for the reputation points.

Regards