Hi!
I want to make a leaderboard and show of who got the top score in what category.
Tabel1 looks like this:
Name | Category | Score | Date | Posted | ID (unique)
And there is 5 categorys, so how do I get the one who got the top score from one category and where the score is the oldest one, becuse they can get the same score but I want the oldest one to still be the leader of that category. Hope you understand.
Highscore.xlsx
Last edited by JCactus; 03-24-2014 at 10:43 AM.
can you upload a sample file?
Click on the star if you think I helped you
A PivotTable can be created using your data as the source that will show you the MAX of each category for each person:
http://screencast.com/t/JR9L1XRj
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Made a sample file now. Not sure if the download will work. Its the main post anyway.
Will take a look when I get home, looks interesting anyway.
tried a different method.
Highscore.xlsx
Did you watch the video I posted above?
No, I do not click on links I do not know where they take you. I do not know screencast.com. This is a protection against malware
A PivotTable looked easy and interesting but I dont want to show off all peoples score, only the top scores.
Adyteo how do I show the names (not ID) of the one who got the top score?
Try with array formula:
In C4:
D4:
Please Login or Register to view this content.
E4:Please Login or Register to view this content.
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.Please Login or Register to view this content.
Quang PT
Im doing something wrong, I still gets the error... Im not even sure when or where to press CTRL+SHIFT+ENTER.
I got Swedish version of Excel can it be becuse of that?
These keypads are on your keyboard.
<crickets>
<crickets>
Did you try the video and suggestion in post #3?
LOL, yea I know where the keys are... But even if I select the cells to fill with your formula and past it then press CTRL+SHIFT+ENTER I still get an error.Originally Posted by bebo021999
It says something like "We found a problem with this formula" "If you write: = 1+1, it shows cell: 2" ....
And it highlights this "Tabell1[Category],$B4"
Last edited by JCactus; 03-24-2014 at 02:35 PM.
It works for me. See attachment
It works for me now too... So I took a look what was the diffrent from the code you gave me and the one from the file you just send and all I could see was this:
From your code "Tabell1[Category],$B4"
From you file "Tabell1[Category];$B4"
Is it just becuse of "," and it shoud be ";"?
And I just notice that in Category 2 it shows "Test" as the leader when it should be "Jack" becuse he got it before "Test", how do I fix that?
Last edited by JCactus; 03-24-2014 at 02:54 PM.
Yes and I have been trying around with piviottable but cant get it the way I want.
Sorry, try again.
Yea now it works just right! Thnx!
Just wish I knew/understood the formula.
Tried to send you an PM bebo021999, but it said your inbox is full.
Anyway I just realized that I want to get the total highscore too, if its possible.
Lets say Jack got the highest score of 8 in category1, and is leading by that score at the leaderboard, but Greg got two scores of 6 and 7 in the same category so he should be leading in the total leaderboard.
So how do I count who is leading in total for each category? Guess I got to use the ID for that as it is unique.
Can you update new requirement to the workbook with desired output?
Highscore-2.xlsx
Done.
find the attachement
Sorry what?
Can you still help me?
Did you see my updated file?
Anyone that can help me to show who is leading each category with the total score?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks