View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Karto Karto is offline
external usenet poster
 
Posts: 7
Default 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(row#:row#)" 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?