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.
Last edited by geoffbanks; 06-30-2009 at 10:42 AM.
Will there be the possibility of have duplicate scores for more than one person?
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Yes, scoring is 3 points 1st, 2 second, 1 3rd, so they could mount up to be the same some of them.
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.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
attached .
Not sure if I misunderstood... take a look at the attached (Sheet2). Is that what you were looking for?
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
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.
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.
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!
gets the names associated with those scores (if duplicates scores exists, names are taken in order they appear in your main sheet).=INDEX(Sheet1!$B$2:$K$2,SMALL(IF(Sheet1!$B$39:$K$39=C2,COLUMN(Sheet1!$B$39:$K$39)-COLUMN(Sheet1!$B$39)+1),COUNTIF($C$2:$C2,$C2)))
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Thats the one, thank you.
Rep'd.
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
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Re: table that updates automatically with the name & highest score
How could you add more people in to this? and change the players to Vertical.
Originally Posted by NBVC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks