autosort formula

[gittermaster]

hi all,
(I hope my english is good enough to make an understandable post)
I have a question and I just cant figure out the answer myself.
Ive made a worksheet for a soccer poule EC 2012.
Everything is working fine, score are calculated correctly etc.

Theres just one little tiny thing I cant figure out.
There are several worksheets.
worksheet 1 is all competitors, their results and their scores.

Now in worksheet 2 ive made a scorelist, pretty simple, just refers to worksheet 1, only in a nice overseight. just 2 rows, row 1 name, row 2 score all refering to worksheet 1.
Works good, no problems so far.
But what I want is that I can autosort from z to a in row 2 (scores). So the number 1 is first, number 2 second etc.
Of course I can change it myself every time, but I want it automatically to be changed as soon as worksheet 1 changes.

example:
I fill in results of matches in sheet 1, as a result of that the score changes and "mark" had now 80 points and "george" 81
In sheet 2 the scores change, but mark with 80 points is still the first mentioned.

Hope I made myself clear and I really hope someone can help me here, since its making me crazy :P

Thx in advance

[gittermaster]

maybe its usefull if I upload my sheet to, to make it easier to understand....

[gittermaster]

maybe I should make it simpler.

sheet a:
row 1 till 27 = Name
row 2 till 27 = result (number)

sheet b:

column A = row 1 from sheet 1
column B = row 2 from sheet 1

just copy/paste only better for overview

How can I autisort column B from high to low (highest result first) (column A; names should change too)
Manually its easy; sort 2 columns click on number and z->a
But what I want is that automatically the person with the highest score is in the top of the list (name = a1 and result = a2)

[martindwilson]

maybe like this

edit removed wrong attachment

[gittermaster]

sir,
thats just perfect!!!!!
Thx a lot, now I can sleep again

[gittermaster]

Close to perfect!
When 2 persons have the same score there occurs a little problem.
We see two times the name "Antidote" instead of "Antidote" and "Herbert"

[martindwilson]

oops typo in rank try this one

[gittermaster]

Now its perfect.

Thanks a lot Martin. You dont wanna know how many hours I spent trying to find it out myself before asking for help

[gittermaster]

oops, I think I was too fast....
Wait, I go check it out more, It looks like now the numbers arent changing anymore

[gittermaster]

Lol, vermind, Im not even gonna tell what I was doing.
Topic can be closed, problem solved. Again thanx a lot

[martindwilson]

well i didnt break it,is your calculation set to auto?

[gittermaster]

hehe, hope you saw my second post (right before your last)! All perfect!
cheers