Mate, you're a genious. Looked all over the web for weeks. Chatgtp took a whole week and was just going in circles. AI has long to go before it can reach people your level. There's no way I would have figured this with that thing. Only a programmer could have pulled this off.
I have another problem to solve for you. I think it can be done using MATCH function and don't think it's that complicated (for you that is).
So, I also wanted the total points (columns O:P) of different positions (1 to 4) to be displayed in ROWS of columns (AD:AG), this way I would be able to calculate the distance between different positions before each matchday later on. I have input the expected results on columns AD:AG. Feel free to change column headings to 1 to 4 and use them as reference cells if needed. Hope I explained myself well.
Hopefully I'm not asking for much.
|