Hi,

I have searched both these forums and google and so far I am just confusing myself.

I have a spreadsheet with teams, all of which have scores for different competitions. Once the total has been tallied i would love to have the groups ranked, i cannot for the life of me think how to do this.. it would purely be a row to the right of total whereby "1st" to "10th" is displayed beside the appropriate team.

Any assistance anyone can offer would be fantastic,

Cheers