table that updates automatically with the name & highest score

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.

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

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.

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

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