Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically put rows containing a number in numerical order
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically put rows containing a number in numerical order
Select the table, (A1:D5) and click DATA in the menu & select SORT. In the
SORT dialog box, click the HEADER ROW option button so it recognizes your column titles. From the SORT BY combo box select WON as the sort column and from the first THEN BY combo box select PLAYED. Click OK to sort. You can record this process as a macro and assign it to a key combintation to make the process more automated. -- Kevin Backmann "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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format column to automatically move rows to date order | Excel Worksheet Functions | |||
How do I create a sales order number automatically? | Excel Worksheet Functions | |||
Need to automatically number order forms in excel upon opening? | Excel Discussion (Misc queries) | |||
Getting Pivot Tables to automatically sort rows in alphabetical order | Excel Discussion (Misc queries) | |||
Can I randomise the order of a number of rows? | Excel Worksheet Functions |