Cell Format within ABCD

If I understand correctly, you want to rate A B C D see the value of X; if there is a string between X, you check Y, then Z.
That is correct. but I forgot to explain something, I have explained below.

How many groups (A B C ...) do you have in general? 4? Or they can be 10, 200, 5000?
Only 4 at least and 8 at most in 1 group. 3 at least but rare.

I created something you need to check.
Thank you and appreciated it.

Try changing the value in the green cell, and check the red (do not change the red cell!). Is that the right way to check the position?
Ok. Yes, that's the way to check the position but there's a little more explanations that I have not described in the exact way that is, To get the real position between A, B, C, D, first need to refer to the most X, secondly refer Y most and third refer Z at least . This is because X is the amount of points collected for the entire game of example between A and B who won the game will earn  1 point, followed by Y is the highest total winning points for each game set (example) 1 to 5 set who is first, while Z is the total of lost point. This means the total number of points Y (needs a lot) and total points Z (need to be less) to determine who is eligible for a position between 1 to 4 (if 1 group has 4).

In the end, you should hide the columns F to J (so you will not see calc).
Ok.

I have attach the another schedule with a difference amounts and example if amount in the red pentagon is less than another should be winner. But If amount in green pentagon are same also the last refer is what i call (head to head) that is very rare due to need check current match between B and D who's win the game should be winner (example) in green pentagon between B and D, D are win the current match and the position is No 1.

I hope you can help me about this. I very appreciated what you have did for me.

Thanks,

Regards,

Uncle Rich...