leaderboard

  1. C

    Ranking with Excel for a Team based on different criteria

    Hi, Please can someone assist, I am trying to create a ranking based on multiple criteria. Each section has been ranked now I would like to see who is leading in terms of a "FINAL RANK" based on all the ranks. please can someone assist me? Please can someone assist with a formula <tbody> MBR...
  2. I

    Working code needs to open results in a different way

    Morning all, I currently have this working code in use "supplied below" but i need it to open the results be shown differently. At present i click a button & i am taken to the worksheet-range in question. This request would be to make it open a different way so i would click the button &...
  3. R

    VBA or Formula needed for Leadeboard / Games Round Creator - Help required please

    Hi All, In a situation here! Below is a Competition Leaderboard that I am working on for a client. What he wants is for each round, each Player will compete against another based on their position on the leaderboard. For example in the below snapshot Jack played Kevin in Round 2 because they...
  4. J

    Saving the current state of excel web app.

    Hi I would really appreciate some help. I have created a quiz in excel And have this set up as a webapp. It includes a leaderboard with name In column j and a score in column k.this leaderboard updates when Someone plays the quiz.so far so good. However the scores do not persist When the app is...
  5. A

    Sumif from list?

    I am trying to create a spreadsheet to track the progress of a bet at the minute, basically the bet revolves around goalscorers in football (soccer) this would then be collated into a leaderboard based on one point per correct selection I am trying to formulate it so that for each correct pick...
  6. M

    Query PGA Leaderboard

    I build a sheet to track fantasy golf that pulled from Masters Tournament Golf Leaderboard and Results - ESPN which worked fine until the tournament ended and the scoreboard changed its format so the sheet that was analyzing the data that was pulled in no longer worked. I found another website...
  7. D

    Running Leaderboard - Help on Ranking Formula

    Hi there, I'm trying to create a running leader board for a competition we're holding at work. On a weekly basis, points will be entered in the yellow cells so competitors can keep track of their progress. I've managed to get the "ranking" formulas working (F3-7 and G3-7) however I need the...
  8. J

    Help developing comprehensive Social Network analytic spreadsheet

    So I'm designing a spreadsheet that will help our company analyse and compare our own social network activity/popularity vs. our competitors. The table, thus far, details the amount of likes/followers that companies (including our own) have on both their Facebook & Twitter accounts. It is...
  9. W

    Rank Only Groups with Same Characteristic

    Good morning, I've been trying to figure this out for a while, but haven't been able to find any resources. Thought you guys will be able to help me solve this. I would like to create a spreadsheet that creates kind of a leaderboard based on geography. To illustrate: Tab 1: Drop down menu...
  10. E

    making a rank equal a value

    Hi, Im running a competition where I need to allocate points. there are 21 people in the competition and I have used the rank function to quickly identify who has came first etc. What I'm wondering, is there a function that can be used to make the rank = a value eg. rank 1 would equal 21...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top