Hi,
I have a table of sport team, which shows, how many goals (with assissts) 2 players scored together (so if player 5 scored a goal and player 16 assisted on this goal they will have one common goal).
There is an example of the table, players numbers are in the first column and row, common goals are for the player from the column and row:
Now, I need in another 3 cells, the amount of most goals of a pair, so the max value of the table (can be done with MAX formula), then the numbers of the 2 players which have that most common goals.
I tried to find them out by INDEX, MATCH, MAX, ADDRESS, CELL... but nothing worked.
Do somebody know, how should I approach this problem?
Thanks!
I have a table of sport team, which shows, how many goals (with assissts) 2 players scored together (so if player 5 scored a goal and player 16 assisted on this goal they will have one common goal).
There is an example of the table, players numbers are in the first column and row, common goals are for the player from the column and row:
5 | 7 | 16 | 23 | |
5 | 3 | 0 | 2 | |
7 | 2 | 0 | ||
16 | 1 | |||
23 |
Now, I need in another 3 cells, the amount of most goals of a pair, so the max value of the table (can be done with MAX formula), then the numbers of the 2 players which have that most common goals.
I tried to find them out by INDEX, MATCH, MAX, ADDRESS, CELL... but nothing worked.
Do somebody know, how should I approach this problem?
Thanks!