Thread: Automatically put rows containing a number in numerical order
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mattlynn via OfficeKB.com Mattlynn via OfficeKB.com is offline
external usenet poster
  
Posts: 140
Default Automatically put rows containing a number in numerical order
you could create a pivot table based upon the data. When you change the data,
you could refresh the pivot, and the data would be automatically sorted in
asceding/descebnding order.



Mally wrote:
Hi

I track results for a Pool League team. Is it possible to automatically
move rows depending on a cell containing a highest number. In the table
below thay have all played 3 games.

Is it possible to move the rows so that they are in numerical order
depending on who has won the most (Column B)

Also if someone is on the same highest amount then it will move on the least
number of games they have played (Column A)

A B C D
1 Name Played Won Lost
2 JOHN 2 0 2
3 FRED 4 3 1
4 SUSAN 3 3 0
5 ALAN 3 1 2

Thanks

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1

Reply With QuoteReply With Quote