I have a list of goals scored by Ronaldo and Messi and have created a manual heat map of where they have scored goals from. I want to write coordinates in a cell in a list and for the heat map to create itself rather than me having to manually input the number in the cell.
The goal list
1 | vs Barcelona | "running total" | Date | Coordinates
2 | vs Getafe | "running total" | Date | Coordinates
3 | vs Galatasary | "running total" | Date | Coordinates
etc etc and the information in the coordinates cell will place a number 1 at the relevant cell on another page that has the layout of a pitch on it. Any conflicting Coordinates in the list will cumulate in the cell.
What (if such a formula exists) would i put in the Coordinates cell in the goal list?
The heatmap looks like this