Dear experts in macros,

I would like to kindly ask you for your advise and help.
I need to the ranking based on 3 columns (values).

Rank values from the first column (B) in the descending matter (that means : the highest value has the rank 1.)
If values in first column (B) are the same, then rank values in second column (C). Here the same, if higher, then rank as 1.
If values in first column (B) and second column (C) are the same, then rank values in third column (D). Again, if higher, then rank as 1.

Explanation. Table is for tenis tournament, column B is for Points per wins (calculated by some my metrics), column C is for difference of Sets (win - lost) and column D is for difference of Games (win - lost).
Here is image which describes how it looks like and also manually done ranking how the rating should looks like.
screen.png

Many thanks for your help and share your great knowledge and experience