General Help
Hey, with the world cup draw just gone, i was trying to make a spread sheet, one page tables, 2nd page results, and all u do is fill in the reults, and then it fills in the table automatic, i managed to do the formula's for, GF (simple, 3 cells added) GA (3 cells added again) and GD (= GF - GA) but i don't know how to do, Games Won, Games Drawn, Games Lost, Points, and for Games played i did, a 1, or 0 next to each fixture, (so i just add a 1 when the game has been played - add all that team's together u get games played) [is there another way for that one??] any help?? -- M4dSk1llz ------------------------------------------------------------------------ M4dSk1llz's Profile: http://www.excelforum.com/member.php...o&userid=29545 View this thread: http://www.excelforum.com/showthread...hreadid=492457 |
General Help
if you do not get a reply from anyone and you would like more help, email me at
Send the workbook and all explanatory notes. http://www.geocities.com/excelmarksway "M4dSk1llz" wrote: Hey, with the world cup draw just gone, i was trying to make a spread sheet, one page tables, 2nd page results, and all u do is fill in the reults, and then it fills in the table automatic, i managed to do the formula's for, GF (simple, 3 cells added) GA (3 cells added again) and GD (= GF - GA) but i don't know how to do, Games Won, Games Drawn, Games Lost, Points, and for Games played i did, a 1, or 0 next to each fixture, (so i just add a 1 when the game has been played - add all that team's together u get games played) [is there another way for that one??] any help?? -- M4dSk1llz ------------------------------------------------------------------------ M4dSk1llz's Profile: http://www.excelforum.com/member.php...o&userid=29545 View this thread: http://www.excelforum.com/showthread...hreadid=492457 |
All times are GMT +1. The time now is 01:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com