Reputation: 61
How to use 1 formula to calculate the number of points (column E) in the previous matches of the team with similar level opponents (columns F and G). Similar level of opponents it is matches against teams from the top or bottom half of the table. For example If the opponent's place in the current cell is <=9 (Column A), then calculating matches against teams with a place <=9, if more, then with a place >9.
For example, for team "Sokol Miedzychod" in row 25, the opponent's place =7, so the formula should calculate the points in the previous matches involving this team (which are above the current cell) against teams whose place is <=9. Next to columns J-K I have manually made a sample with simple formulas of what should be obtained.
In columns I-J, I made a sample of what the end result should be. I think map + lambda + sumifs will work, but I don't know exactly what the formula is supposed to look like.
Link on file: https://docs.google.com/spreadsheets/d/1nMy3fWJ3hmf7Bm_jGhqknmS__3IzRopBKuqfU9s_quQ/edit?gid=2076631193#gid=2076631193
Upvotes: -2
Views: 48