Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Sorting numbers and text separately | Excel Discussion (Misc queries) | |||
How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
Negative numbers turn positive automatically on data entry | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |