Running Leaderboard - Help on Ranking Formula

[debelah]

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 weekly points (yellow cells) to MOVE with the ranking. Is this possible at all? Please see the attached worksheet for what I mean.

Thanks in advance!

Debs

 

[Fishboy]

Hi Debs,

As far as I can see there there are no links in your post that point towards any workbooks. It is not possible to upload documents directly to the forums, you would need to host the file on something like Dropbox, One Drive or similar, then provide a link to the file here on the forums.