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?

"Adrew" <Adrew@discussions.microsoft.com> wrote in message news:68AF3C4A-7367-45AD-9144-871725B3D0C8@microsoft.com...
> 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

Hi A,

See xlDynamic's League Table page at:

http://www.xldynamic.com/source/xld.LeagueTable.html



---
Regards,
Norman



"Adrew" <Adrew@discussions.microsoft.com> wrote in message
news:68AF3C4A-7367-45AD-9144-871725B3D0C8@microsoft.com...
> 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?

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" <Adrew@discussions.microsoft.com> wrote in message
> news:68AF3C4A-7367-45AD-9144-871725B3D0C8@microsoft.com...
> > 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?
>
>
>

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" <Adrew@discussions.microsoft.com> wrote in message news:68AF3C4A-7367-45AD-9144-871725B3D0C8@microsoft.com...
> > 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