League Table Help

[Bennets04]

Good evening all,

Im having small issue trying to get my head around a league table i have to make... Basically there are 84 teams who need a specific KPI ranked daily for the rest of this month. Basically the bottom 10 drop out daily and can only enter if they are in the top 10 at any point for the remainder

The aim is to produce a table come the end of the campaign showing the teams remaining

Any ideas or thoughts? was thinking of a daily copy and paste the performance into separate sheets but then was unsure on a formula without having to do it manually

 

[AFPathfinder]

Each day, you are removing 10 teams from your list and possibly adding more if dropped teams score in the top 10? To reduce work, I'd suggest having a dedicated column to distinguish each team as in or out.

Where are the stats coming from? You might be able to link a web table. Most likely, though, it's probably going to be a few formulas that can pull the data from an imported table.