Not sure if this is the correct forum for this since I can't find an absolute applicable one I kind of figured that being this would be the best selection.
Using Google Docs for a spreadsheet since it the easiest way for multiple of us to update points of the 50+ people and allow all to see where they are at position wise throughout the season.
So my issue is I'm doing a spreadsheet to keep track of scoring throughout a season. What I want to do is have a leaderboard that shows the top people with in the season at all times with their score and name. The main issue is running into ties and I'm not exactly sure what command to use, I want to show the top five players (points and names).
Using, =LARGE(B2:B76,1) through =LARGE(B2:B76,5) I can show the numbers but with ties I'm unsure that this would work. I want to see peoples names beside this and if multiple people are tied I'm not sure how to return the values of their names.
I'm just trying to work this out at this moment if anyone have insight to what I could do any help would be appreciated! Thanks!
http://i112.photobucket.com/albums/n184/Nagello/test_zps1aafa668.pngThis post was edited by Nagello on Jan 13 2013 08:10pm