LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Hugh Murfitt
 
Posts: n/a
Default Highest score in team

I have a team sheet listing players names against their accumulated score.
I want to re-order this list, on a new sheet, such that the player with most
points is listed at the top, the player with the next most is under that one,
and so on. I dont want to use €śsort€ť as I want the players names to re-sort
as I key in their scores after each match.
Is there a worksheet function (or combination of functions) that will allow
me to do this? How will is sort if two players have the same score?
 
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
Highest Value / Circular Reference Help Josh M Excel Discussion (Misc queries) 1 May 23rd 05 07:33 PM
Highest Value / Circular Reference Help Josh M Excel Worksheet Functions 0 May 23rd 05 06:49 PM
Barb Reinhardt: HOW TO: Plot a Team Name .... Kevin McCartney Charts and Charting in Excel 2 December 1st 04 01:28 PM
HOW TO: Plot a Team Name on a chart based on two values Kevin McCartney Charts and Charting in Excel 1 November 30th 04 05:26 PM
Highest score soxn4n04 Excel Worksheet Functions 3 November 29th 04 02:53 PM


All times are GMT +1. The time now is 03:39 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"