Amazing!!! Thank you so much, this guide was the best one!! only column I changed was the GD and moved it in between Points and GA. The only thing that is not working for me is the fact that you all have the pre populated teams in, what if the fixtures are not yet released, and I am entering them weekly, the played column does not work properly. For example, i have two teams played two games only(1 home 1 away) , but it is showing that they have played 4 times.
First of all, thank you very much for this helpful video. I have a question: When all results are the same, ranking is not working. It says #N/A after only ranking one club. How can I fix this problem? Thank you in advance.
Thanks for this informational video! It's been helping alot with this tournament app I'm working on. I had a question which I wonder if you or anyone in the comments was able to figure out, but how would you set the Matches played tab to only change once the score is inputed. For example, The Matches played would be 0 or blank until the scores of the first games are put in. Then It would change to 1. Because at the moment, matches played is already set before scores are put in due to the fact that it bases it on how many times the team name appears.
Okay this was great but I encountered a problem where 1 team had the same exact record, so the rank was repeated in number 17, 17 and therefore it simply repeated one team's name instead of putting both teams' names with the same record
Can we do to 10 teams and for half of competion only? And im using older ver. Of excel so tge formula unique is not working where can i find the other way?
I'd like to do this with multiple leagues per tab: EFL in tab 1; National in tab 2; regional in tab 3 etc. I have worksheet with 35 leagues which means 35 tabs. Surely there must be a way to consolidate into a handful of tabs without the tables assuming all games not yet played are 0-0 draws.
This is excellent. However, I have followed this video and adapted it for the Championship 2020/2021 and encountered a couple of minor issues. One, Sheffield were deducted 12 points (although that was later reduced to 6 points). Can this workbook be modified to handle this please? And two, particularly at the start of the season, Ranking results in #N/A for many teams. I know this is because these teams are identical in terms of points, goal difference, and goals for. How can we get a unique rank for these? Once again, very good video. Thank you.
Thanks so much for your comments and apologies for delay - I have been off for a week or so. Give me a couple of days and I will get a new video up to help you with this. Hit subscribe to make sure you dont miss it!
Please friend, can you make tutorials on how to get recent football form with date, teams home and away, and results from their last games played, thank you!
Hi, I have just followed your instructions, but have encountered an issue, whilst you have provided an algorism to order teams, the output does not respond to two teams having an identical record, not much of a problem towards the end of the season but if teams draw their first match for instance this does not work, is there a way the team name can be used alphabetically to overcome this issue??
I have managed to find a work around, I added an extra column to the calculations spreadsheet and working from the bottom team up added extra variable 0000.11 then 000012 etc and added this to the formula.
@@MultiFuzzywazzy please can you explain that in more detail? I'.d like to use this by building the raw data gradually from the start of season. I also have an issue with a team being deducted points
Hi there, I have recreated this table for the 2020/21 Premier league season and have encountered a problem. For certain teams (4 in particular), the away result is not being counted and hence they are showing as having played as half as many games. The formula is working for the 16 other teams and I can see where I have gone wrong, any help would be appreciated!
This helped me create group stage tables for this years euros. Thank you! Is there a quick way to extract that league table data into a knockout stage? In this tournament there are complications because there isn't a fact (in advance) which 3rd places are going through to knockout. Only 4/6 3rd places go through. Again, thank you for a great video!
Hi.Sorry for delay - I took 7/10 days off! Back now though. Give me a couple of days and I will get another video up to do this for you. Don't forget to hit subscribe to make sure you dont miss it!
HI Dennis. Apologies for confusion. Column E is Column C - Column D. It is not actually used in the table (not sure what I was thinking about when I did it!)
@@hammjai Hi Dennis - clearly a bad day! First off Email address is admin@expandyourskills.co.uk - that will work! Secondly you are of course correct. Column E is calculated as the difference between C & D and is used to decide if a game was won, lost or drawn. This does demonstrate the importance of keeping notes on how a spreadsheet is built - this was one of the first spreadsheets I did for public viewing and I didn't keep the notes - I do now by creating a separate tab! Thanks for the contact.
Countif function shows wrong results and wrong totals...... in the wins columns..... in the fixtures list each team repeats 38 times whereas it registers only 5 or 6 for each team
Amazing!!!
Thank you so much, this guide was the best one!! only column I changed was the GD and moved it in between Points and GA.
The only thing that is not working for me is the fact that you all have the pre populated teams in, what if the fixtures are not yet released, and I am entering them weekly, the played column does not work properly. For example, i have two teams played two games only(1 home 1 away) , but it is showing that they have played 4 times.
First of all, thank you very much for this helpful video. I have a question: When all results are the same, ranking is not working. It says #N/A after only ranking one club. How can I fix this problem? Thank you in advance.
Thanks for this informational video! It's been helping alot with this tournament app I'm working on.
I had a question which I wonder if you or anyone in the comments was able to figure out, but how would you set the Matches played tab to only change once the score is inputed. For example, The Matches played would be 0 or blank until the scores of the first games are put in. Then It would change to 1.
Because at the moment, matches played is already set before scores are put in due to the fact that it bases it on how many times the team name appears.
i think its iferror,0 at end but dont trust me
This was very helpful - I learned a lot and it works like a charm in Google Sheets. Thank you!
This was awesome! 👍
How do you transfer the teams from the raw data to the calculations tab if you dont have the excel 365?
Okay this was great but I encountered a problem where 1 team had the same exact record, so the rank was repeated in number 17, 17 and therefore it simply repeated one team's name instead of putting both teams' names with the same record
its helpful but ONLY if the league is completed what about per game
Can we do to 10 teams and for half of competion only?
And im using older ver. Of excel so tge formula unique is not working where can i find the other way?
I really liked what you did with the column function in the VLookUp near the end. Thanks.
You are welcome!
How did you get the coloum E in raw data,
I'd like to do this with multiple leagues per tab: EFL in tab 1; National in tab 2; regional in tab 3 etc. I have worksheet with 35 leagues which means 35 tabs. Surely there must be a way to consolidate into a handful of tabs without the tables assuming all games not yet played are 0-0 draws.
This is excellent. However, I have followed this video and adapted it for the Championship 2020/2021 and encountered a couple of minor issues. One, Sheffield were deducted 12 points (although that was later reduced to 6 points). Can this workbook be modified to handle this please? And two, particularly at the start of the season, Ranking results in #N/A for many teams. I know this is because these teams are identical in terms of points, goal difference, and goals for. How can we get a unique rank for these? Once again, very good video. Thank you.
Thanks so much for your comments and apologies for delay - I have been off for a week or so. Give me a couple of days and I will get a new video up to help you with this. Hit subscribe to make sure you dont miss it!
Please friend, can you make tutorials on how to get recent football form with date, teams home and away, and results from their last games played, thank you!
How can we set this up for hockey 1 pt OT loss?
Hi. How can I get in touch with you directly re help creating a new league project and inputting onto video?
Hi, I have just followed your instructions, but have encountered an issue, whilst you have provided an algorism to order teams, the output does not respond to two teams having an identical record, not much of a problem towards the end of the season but if teams draw their first match for instance this does not work, is there a way the team name can be used alphabetically to overcome this issue??
I have managed to find a work around, I added an extra column to the calculations spreadsheet and working from the bottom team up added extra variable 0000.11 then 000012 etc and added this to the formula.
@@MultiFuzzywazzy please can you explain that in more detail? I'.d like to use this by building the raw data gradually from the start of season. I also have an issue with a team being deducted points
Great solution. I will upload a video over next few days to explain this in more detail for others. Cheers
Sorry for delay but I have uploaded a new video to help rank teams alphabetically (if all else fails!) ruclips.net/video/zbmSHWI3JTE/видео.html
Hi there, I have recreated this table for the 2020/21 Premier league season and have encountered a problem. For certain teams (4 in particular), the away result is not being counted and hence they are showing as having played as half as many games. The formula is working for the 16 other teams and I can see where I have gone wrong, any help would be appreciated!
Hi James. Happy to help - can you email me what you have done so far to admin@expandyourskills.com. Cheers
This helped me create group stage tables for this years euros. Thank you! Is there a quick way to extract that league table data into a knockout stage? In this tournament there are complications because there isn't a fact (in advance) which 3rd places are going through to knockout. Only 4/6 3rd places go through. Again, thank you for a great video!
Same here 😂
Me too 😂
Hi, I am using an older version and it does not have a unique function. how do I go about it?
Hi.Sorry for delay - I took 7/10 days off! Back now though. Give me a couple of days and I will get another video up to do this for you. Don't forget to hit subscribe to make sure you dont miss it!
Where did the Raw Data Column E values come from? Unexplained in vdo?
HI Dennis. Apologies for confusion. Column E is Column C - Column D. It is not actually used in the table (not sure what I was thinking about when I did it!)
@@expandyourskills Hi there. It's not a big issue. However, you do have a calculation counting your Wins and Draws and refer to column E >0, E
@@hammjai Hi Dennis - clearly a bad day! First off Email address is admin@expandyourskills.co.uk - that will work! Secondly you are of course correct. Column E is calculated as the difference between C & D and is used to decide if a game was won, lost or drawn. This does demonstrate the importance of keeping notes on how a spreadsheet is built - this was one of the first spreadsheets I did for public viewing and I didn't keep the notes - I do now by creating a separate tab! Thanks for the contact.
@@expandyourskills we all have odd days off! Take care. Dennis.
can u teach me how to rank teams arcording to points --> head to head record ?
I sure can! Video will be going up at weekend - make sure you are subscribed so you dont miss out
@@expandyourskills looking forward that video :)
@@expandyourskills didn't see that video ??
Very well explained.
Countif function shows wrong results and wrong totals...... in the wins columns..... in the fixtures list each team repeats 38 times whereas it registers only 5 or 6 for each team
Thank you!
I know its 3 months later...but thank you.
Thanks Mr Mongoose! That is much appreciated. Please subscribe to the Channel to ensure you don't miss future videos. Coming Soon!