In column A I have unique IDs (10001 up to 19999).
In column B I have countries,
In column C I have fruit names,
In column D I have values (between 1 and 10000)

If I have a unique ID - lets say ID 14592
It's corresponding country is Australia, and corresponding fruit is Pear,
and corresponding value is 1000

I want to know its rank in its class.
- its rank for all Pears
- its rank for all Australians
- its rank for all Australian Pears.

Can someone help with the formula for this? Say the ID (14592) is entered
in F1

Thanks in advance!

Daniel