Sorting Data in a Row Question

I run a Cub Scout pack & know very little about excel & need help with a project I am working on.

Basically, it's laid out like this:
Names: player 1, player 2, player 3, player 4, so on
Total: (total) , (total) , (total) , (total) , etc
Place: 4th 2nd 1st 3rd
round 1
round 2
round 3
round 4
so on

The cell that says (total) contains "=sum(Col#:Col#)" so basically it shows each players total after each round.

I need help using the cells containing the totals to figured who has the most points, second most, 3rd most, etc & then display something in the "Place" row to designate which player is in 1st, 2nd, 3rd, & so on.

Is this something that can be done simply?

Hi

For example if your totals are in the range A1:A5 and the order (rank) to be in the cell below then place the following in B1

Please Login or Register  to view this content.

and copy across.

Regards

Jeff