I have a spreadsheet that is updated everyday with points for a contest. My goal is to have columns M, N, and O updated daily with the totals of the contest (Column K). Column M being the name, N being the point total of the associated name, and O being the rank (1 being the best at the top).
Add-On Contest.xlsx
Thanks for your help.... and if you can please let me know the formulas in reply as I am unable to download sheets due to my firewall at work.
In N5
=LARGE($K$5:$K$18,ROW(A1))
In O5
=RANK(N5,$N$5:$N$18)
In M5
=INDEX($B$5:$B$18,MATCH(N5,$K$5:$K$18,0))
Copy down
These wont work satisfactorily in case of duplicate scores though.
Life's a spreadsheet, Excel!
Say thanks, Click *
A lot of the scores tend to be duplicates - is there a way around this?
Find the attached file
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Try this.......
In N5 (Array Formula which requires confirmation with Ctrl+Shift+Enter instead of just Enter.)
and copy down.
Please Login or Register to view this content.
In O5
and copy down.Please Login or Register to view this content.
In M5 (again an Array Formula which requires confirmation with Ctrl+Shift+Enter)
and copy down.Please Login or Register to view this content.
Last edited by sktneer; 07-24-2014 at 09:16 AM.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Or this...
Thanks for the feedback.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Here is something that you could try. A helper column is used to break ties.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks