ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sorting Data in a Row Question (https://www.excelbanter.com/excel-discussion-misc-queries/219662-sorting-data-row-question.html)

Karto

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?


All times are GMT +1. The time now is 03:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com