How can I sort a group of numbers automatically as data is entere

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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?
Click to expand...

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,
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
 
Back
Top