Hi, I have had a look at your spreadsheet and it works perfectly fine for me. The problem might be because you need to use the latest version of Excel so you probably have to update your Excel. Let me know if this works
Hi mate, I have had a look at this and there is not a problem in the formulas of my spreadsheet. It could possibly be due to your thousands and decimals separators in your FM or Excel settings or maybe you have accidentally tampered with the formulas by adding in a column. Maybe download a fresh copy of the spreadsheet or follow the instructions below.
Follow these steps:
1) Click File > Options
2) Go to the Advanced tab and uncheck Use system separators
3) You should set the decimal and thousands separator to match with the ones in your FM23 settings
Are you using the latest version of Excel?
Yeah I completely agree, it is very frustrating having to flick through multiple Excel sheets to keep a record of player data when it can be done by the game.
Hi! Thanks for pointing that out, I hadn't realised I had forgotten to unlock those columns. I have posted a link for the updated version of the spreadsheet which allows you to sort the tables.
https://www.mediafire.com/file/rtaxuq2x2k1xhjw/FM24_FMSS_Spreadsheet_v2.zip/file
Hi, the problem is that the minutes column uses a point instead of a comma for the thousands separator.
If that doesn't work, you can select the whole column AP and press CTRL + H, and replace the dot with a comma.
Unfortunately I am not an analytics professional, I am just a busy university student . All the knowledge that I have gained in analytics and creating data visualisation was from using ideas from others such as @MattyLewis11 and self-experimentation .
Thank you and no problem!
That is really weird as @BL1TZ_GT has had the same problem and I tried it with his Excel sheet and had no problems. This could possibly be due to the version of Excel you are using?