Depending on how many countries you are dealing with, I would run a sort where the first level is country, the next is number of units, and the third is revenue. You could then add the rankings by dragging down numbers. Due to the sort, everything should be in the correct order and all you have to do is add a rank.

If you posted a sample worksheet, I believe people would be more willing to help out.