Hello,

A general approach without the RANK function which works for numbers
and texts:
Enter into E1:F2
Composite Text Rank
=TEXT(D2,"00000.00")&TEXT(MIN(B2:C2),"00000.00") =COUNTIF($E$2:$E
$5,""&E2)+COUNTIF($E$2:E2,E2)
and copy E2:F2 down.

Regards,
Bernd