SWRevolution
New Member
- Joined
- Apr 30, 2018
- Messages
- 1
I'm building out a database of Football statistics for the Football Teams I support, however an issue I have is that it is all automated, except for the average rating for the past three matches (Recent Form). At the moment I have to manually select the cells that would contribute to this statistic. I know how to average the last three cells of a range, however depending on where the player plays and the formation that is used, their name can end up in a different column match-on-match. Here's an example (For the sake of this example the cell with "Starting XI 1" is cell E2. Column A is the player names and Column B is the Number of Games Played and Column C is Recent Form. In Cell C2 (For "Lucas" the Formula I have is "=IFERROR(SUM(AD3, S4, AB5)/IF(B2<3, B2, 3),6)"
<tbody>
</tbody>
Any help would be much appreciated!
| Starting XI 1 | Rating | Starting XI 2 | Rating | Starting XI 3 | Rating | Starting XI 4 | Rating | Starting XI 5 | Rating | Starting XI 6 | Rating | Starting XI 7 | Rating | Starting XI 8 | Rating | Starting XI 9 | Rating | Starting XI 10 | Rating | Starting XI 11 | Rating | Sub 1 | Rating | Sub 2 | Rating | Sub 3 | Rating |
| Lloris | 5.4 | Trippier | 6.6 | Sánchez | 6.6 | Vertonghen | 7.3 | Davies | 6.9 | Dembélé | 7.1 | Dier | 7.1 | Lamela | 6.4 | Eriksen | 7.6 | Dele | 6.6 | Kane | 6.9 | Son | 6.2 | Lucas | 7.3 | Sissoko | 6.5 |
| Lloris | 7.2 | Aurier | 6.5 | Alderweireld | 7 | Vertonghen | 6.8 | Davies | 6.7 | Sissoko | 6.5 | Wanyama | 6.6 | Lucas | 6.7 | Eriksen | 6.4 | Son | 7 | Kane | 8 | Dembélé | 6.7 | Lamela | 6.4 | Llorente | 6.6 |
| Vorm | 6.4 | Trippier | 6.5 | Sánchez | 6.6 | Vertonghen | 7.6 | Davies | 5.8 | Dier | 7.5 | Dembélé | 6.5 | Eriksen | 7.8 | Dele | 7.7 | Son | 6.6 | Kane | 7.1 | Lucas | 6.8 | Wanyama | 6.7 | Lamela | 6.9 |
<tbody>
</tbody>
Any help would be much appreciated!
