Points scored over the last 30 days instead of total points over total days.

[dougkpga]

I have 3 people in a competition and want to make a leaderboard.

I have achieved this but I don't know how to make it a rolling leaderboard by showing the leader for the last 30 days.

At the moment they get an "L" for leading converted to a score getting 1 point for every time they lead on the day.

Then they have a total where any point scored is added to their previous total.

Then converted to a percentage.

So their total score is divided by the number of days.

Is there a way to make their total score and percentage for the last 30 days.

eg Day 40 would be the points over the last 30 days divided by 30 instead of the points for the last 40 days divided by 40 days which I have at the moment.

I have attached my spreadsheet.

Thanks in advance for any help.

Doug

[JohnTopley]

Try

in E31

Please Login or Register  to view this content.

copy down

[windknife]

Try this,
D2
=SUM(INDEX(C:C,MAX(2,$A2-29)):C2)

E2
=D2/(ROW()-MAX(2,$A2-29)+1)*100

copied down and copied to H、I、L、M columns.

[TMS]

Do you mean something like this:

Please Login or Register  to view this content.

[dougkpga]

Thanks to all of you - Reps added to each - It is really late here in Australia (after midnight) so will try them all tomorrow. Thanks again. Doug

[windknife]

You are welcome.

[TMS]

You're welcome. Thanks for the rep.