Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 390
Default Sorting

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
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
Automatic sorting (giving max and min) based on custom sorting lis Joe Lewis[_2_] Excel Worksheet Functions 4 November 23rd 08 05:12 AM
Sorting VLookup vs Sorting SumProduct Lauren Excel Discussion (Misc queries) 1 August 21st 07 12:19 AM
Sorting: Sorting by the First Character dzuy Excel Discussion (Misc queries) 2 June 22nd 06 08:27 PM
Sorting David McRitchie New Users to Excel 0 April 20th 06 02:32 AM
sorting Harsha Excel Discussion (Misc queries) 1 March 23rd 06 12:55 PM


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