table that updates automatically with the name & highest score

[geoffbanks]

Ok, kinda noob to excel getting it to work out this stuff.

I want to create a table that updates automatically with the name & highest score top.

I.E. currently I have :-

Dates starting in A4,
names B2 : K2,
scores B4 : K4,

Not too fussed about having the date in the results table but i'd like something like :-

Scott 4 points,

Geoff 7 points

Tony 2 points,

I would like a table to automatically sort a table (preferably on sheet 2) so it looks like :-

Geoff 7
Scott 4
Tony 2

Is this possible ?, I only have 6 rows of data so far so it can be re-arranged if needs be and data will be added each week.

Hopefully some clever person can help me lol.

[NBVC]

Will there be the possibility of have duplicate scores for more than one person?

[geoffbanks]

Yes, scoring is 3 points 1st, 2 second, 1 3rd, so they could mount up to be the same some of them.

[NBVC]

Maybe you can attach a sample spreadsheet showing the layout and some sample scores along with what you would like to see as an outcome... this would make it easier to get you exactly what you need.

[geoffbanks]

attached .

[NBVC]

Not sure if I misunderstood... take a look at the attached (Sheet2). Is that what you were looking for?

[geoffbanks]

A table like that but in total & automatically.

So the total of Stu's scores 3,3,1,1 added and slotted in the table where his score belongs, so 8 total so far but if he gets 2 next week I can input 2 in sheet one and his total would be 10 in the table, but if someone has more they go above him etc...

You get what I mean ?, basically like a sporting table with team names and their scores, if they win they go up the table, if they lose they stay the same, where in my case a 0 score in that week would keep them in the same place.

Sorry hard to explain as I don't know the right way to word it.

[geoffbanks]

A table like this http://www.nba.com/standings/team_re...w_Std_Cnf.html , so if boston gets 7 points they would go top and cleveland second.

Thats what I want,

Person name, points.

EDIT : 7 wins in the above example.

[NBVC]

Then perhaps something like the attached....

I used your sums in B39:K39 to create formula in C2 of Sheet2!

=LARGE(Sheet1!$B$39:$K$39,ROWS($A$1:$A1)) copied down to get largest to smallest overall scores..

Then formula in B2 of Sheet2!

Please Login or Register  to view this content.

gets the names associated with those scores (if duplicates scores exists, names are taken in order they appear in your main sheet).

[geoffbanks]

Thats the one, thank you.
Rep'd.

[NBVC]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[byron.lumley]

How could you add more people in to this? and change the players to Vertical.

Then perhaps something like the attached....

I used your sums in B39:K39 to create formula in C2 of Sheet2!

=LARGE(Sheet1!$B$39:$K$39,ROWS($A$1:$A1)) copied down to get largest to smallest overall scores..

Then formula in B2 of Sheet2!

Please Login or Register  to view this content.

gets the names associated with those scores (if duplicates scores exists, names are taken in order they appear in your main sheet).