Forum Discussion
ozzie4khawaja
Mar 10, 2021Copper Contributor
Finding the Right Excel Formula and putting it together
Hi All, This is my first time using this forum but I've hit a roadblock. I'm trying to create a tool/calculator for the line of work which is scouting football/soccer players across the world and to...
Riny_van_Eekelen
Mar 11, 2021Platinum Contributor
ozzie4khawaja It does on my machine.
ozzie4khawaja
Mar 11, 2021Copper Contributor
Hi Riny, I've tried to follow your formula and input that into my workbook but my results don't match yours. I'll attach my worksheet to the main post. Your A & B column cells are on the main calculator tab under the first greyed out box and the table is under FIFA Ranking. Can you tell me where I'm going wrong?
- Riny_van_EekelenMar 11, 2021Platinum Contributor
ozzie4khawaja Sorry, you loose me here. I know nothing about football and find the form quite confusing. Kindly fill it in with an example and indicate where the calculation is made and what's wrong.
- ozzie4khawajaMar 12, 2021Copper ContributorOk i'll send you the screenshots for you to see, hopefully that will help
- ozzie4khawajaMar 12, 2021Copper ContributorNow attached, i've highlighted the formula i've used, the cells involved and the table which is on another tab. Hopefully this should remove any confusion.