I am trying to rank some data but with a condition.
Best seen by example:

Country Sales Value Rank Per Country
AUST. Dave 25 3
AUST. Bob 28 2
AUST. Alex 22 4
AUST. Phil 12 5
AUST. Rob 29 1
CHINA Janes 28 1
CHINA Phil 25 3
CHINA Dan 27 2
CHINA Alex 4 5
CHINA Bob 23 4

So I want to rank the value but per country, and the data is not in
order. In the real example there are a lot more countries. Ultimately
I would like to do this with multiple conditions, but happy to not
overcomplicate at this stage.

Any help much appreciated.
Thanks
Matt