If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I sort a group of numbers automatically as data is entere
I'm designing a spreadsheet to record the World Cup football scores. I've got
the leagues to take scores from the match results but I now want the leagues to sort by points/goal diff/goals scored as match socres are entered. Is this possible? |
#2
|
|||
|
|||
How can I sort a group of numbers automatically as data is entere
"Adrew" wrote in message ...
I'm designing a spreadsheet to record the World Cup football scores. I've got the leagues to take scores from the match results but I now want the leagues to sort by points/goal diff/goals scored as match socres are entered. Is this possible? You have names in column A ordered alphabetically, scores in column B. As soon as you enter a score aside of a name it appears an entry in the table (three columns) as below. Nomi Tempi Classifica Tempi Nomi A 12 1 2 C B 2 6 F C 2 3 8 D D 8 4 12 A E F 6 Is this layout ok for you? Bruno |
#3
|
|||
|
|||
How can I sort a group of numbers automatically as data is entere
Hi A,
See xlDynamic's League Table page at: http://www.xldynamic.com/source/xld.LeagueTable.html --- Regards, Norman "Adrew" wrote in message ... I'm designing a spreadsheet to record the World Cup football scores. I've got the leagues to take scores from the match results but I now want the leagues to sort by points/goal diff/goals scored as match socres are entered. Is this possible? |
#4
|
|||
|
|||
How can I sort a group of numbers automatically as data is en
Just what I wanted thank you very much1
Andrew "Norman Jones" wrote: Hi A, See xlDynamic's League Table page at: http://www.xldynamic.com/source/xld.LeagueTable.html --- Regards, Norman "Adrew" wrote in message ... I'm designing a spreadsheet to record the World Cup football scores. I've got the leagues to take scores from the match results but I now want the leagues to sort by points/goal diff/goals scored as match socres are entered. Is this possible? |
#5
|
|||
|
|||
How can I sort a group of numbers automatically as data is en
Hi,
Thanks for the response. I'll have to experiment a bit. I've got it to the point where the league tables will pick up all the details from a table of results. I'll try this to see if I can make it sort the table. Thank you. Andrew "Bruno Campanini" wrote: "Adrew" wrote in message ... I'm designing a spreadsheet to record the World Cup football scores. I've got the leagues to take scores from the match results but I now want the leagues to sort by points/goal diff/goals scored as match socres are entered. Is this possible? You have names in column A ordered alphabetically, scores in column B. As soon as you enter a score aside of a name it appears an entry in the table (three columns) as below. Nomi Tempi Classifica Tempi Nomi A 12 1 2 C B 2 6 F C 2 3 8 D D 8 4 12 A E F 6 Is this layout ok for you? Bruno |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can an Excel Spreadsheet automatically sort new data? | Stumped | Worksheet Functions | 2 | November 8th, 2005 04:26 PM |
Can I group data on different rows together and then sort the grou | Stephanie | Worksheet Functions | 4 | October 12th, 2005 12:45 PM |
Sort pages? | David | General Discussion | 15 | May 13th, 2005 11:33 PM |
Syntax needed to get needed reports | Frank Lueder | New Users | 15 | January 6th, 2005 08:39 AM |
Help Needed for Groups Please | Paul Black | General Discussion | 15 | June 21st, 2004 02:54 AM |