Hi, I have a spreadsheet with values as per below
I can rank the data based on descending values in Columns B & C using the formula in cell B2
=RANK(B2,$B$2:$B$11)+SUMPRODUCT(--($B$2:$B$11=B2),--($C$2:$C$11>C2))

What I trying to do is also rank the data based on the values in column D as an additional tie-breaker, any thoughts?
Thanks

Rank Score 1 Score 2 Score 3
1 41 23 15
2 40 24 20
2 40 24 22
4 40 20 30
5 39 20 15
6 38 20 16
7 38 19 15
8 38 18 16
9 36 19 15
10 35 19 16