3 posts shown.
Kyle Johnson2 I can't really help you out here. I don't have the bandwidth to dive deep and play philosopher trying to figure out "what the poet meant."
What do you mean you can't help? You solved it! Just use CONCATENATE 🙂 and call it a day. Thanks a lot.
Here’s the link to download the spreadsheet.
http://www.fileconvoy.com/dfl.php?id...86ede06bb06b69
The password to open it is football.
The data I was looking for is on the last statistics page.
If anyone can help me out, I'd appreciate it.
I put together an Excel sheet to track soccer scores. I have one sheet where I log Team A, Team B, and the score (like 3:1), then everything calculates automatically—points, goals scored, goals conceded—and feeds into a master standings sheet sorted by goal differential and all that. I’ve got a hidden helper sheet doing the heavy lifting too. Now I’m trying to build out a third sheet for deeper stats, but I've hit a wall. I need to pull the biggest win and biggest loss for each specific club, plus identify the single largest margin of victory and defeat for the entire league (including which teams were involved). So far, I’ve been splitting the scores into separate cells using formulas like (=VALUE(LEFT(C2,FIND(":",C2)-1))) and (=VALUE(RIGHT(C2,LEN(C2)-FIND(":",C2)))) to isolate home and away goals, but I can't figure out how to calculate the max win or loss for an individual team. Anyone have any ideas or a way to tackle this?