LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting Question Curtis S. Excel Worksheet Functions 1 October 11th 06 05:39 PM
sorting question kolonelvonklink Excel Discussion (Misc queries) 2 August 22nd 06 12:20 PM
sorting question LewR Excel Discussion (Misc queries) 4 May 3rd 06 02:10 PM
Sorting Data question RPIJG Excel Worksheet Functions 1 August 19th 05 07:47 PM
sorting question Brian Excel Discussion (Misc queries) 4 November 28th 04 12:30 PM


All times are GMT +1. The time now is 10:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"