I am organinsing a girls football tournament and have got some very good xls sheets, however the points structure is not correct and i do not know how to change it
I need it to show 3 points for a win, 2 points for a score draw and 1 point for a no score draw. this is the current formula that give just 3 points for a win and 1 point for any draw.
Any help much appreciated
Ken Puls, FCPA, FCMA, MS MVP (Excel)
Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.