Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Team PLAY WIN DRAW LOSE GF GA GD POINTS
------------------------------------------------------------------------ Inter 26 18 6 2 47 21 26 60 lazio 26 16 5 5 42 21 21 53 Milan 26 14 6 6 43 27 16 48 lecce 26 14 4 8 38 25 13 46 Roma 26 12 9 5 36 25 11 45 ---------------------------------------------------------------------- This is part of a table where the data is coming from a source showing below. [G-1] - 14/09/08 - 28/01/09 - [G-20] ----------------------------------------- 0 - 1 Bologna Atalanta 1 - 0 2 - 0 Genoa Milan 1 - 1 2 - 1 Inter Catania 2 - 0 1 - 0 Lecce Udinese 1 - 2 ------------------------------------------- [G-1] means --- game No:1, where for example Bologna is at Home. [G-20] means--- game No:20, means 2nd round, where Bologna is Away. The figures beside the teams' name are the results. I am not using any macros, just simple functions. The table is updated whenever I put the results. Everything works perfect but I have to sort the table in this manner. The team with the more points ,then with the best GD, then with the best GF. Will you please help me so when I put the results, the table will update without the need to sort. I am working with Excel 2007. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
Sorting | New Users to Excel | |||
sorting | Excel Discussion (Misc queries) |