softball standings
I run a softball league and I post standings every week. What I want to do is put a W or a L to the left of the team name and then have excel up date the win and loss colums. So the 8 wins will now be 9 and so on. I could not understant the answer that was given to laceyMKSTP. Randy TEAMS WINS LOSSES W Edwardsville Moose 8 1 W B&K Towing 8 1 W MDB Eleclectri 7 2 L Thunder 6 3 L Elevator Tavern A 5 4 L Tri Ford 4 5 W Elevator Tavern B 3 6 L K J Ducks 2 7 W R&B Electric 2 7 L K&K Krushers 0 9 -- randyrestg ------------------------------------------------------------------------ randyrestg's Profile: http://www.excelforum.com/member.php...o&userid=24512 View this thread: http://www.excelforum.com/showthread...hreadid=381054 |
Surely your best bet is to keep all the records in the sheet and produce a report from that Dalla Dullards 7 2 W L W W W L W W W The only other way I can think of is to use an event to update the totals when you enter the W/L in col 1, but it would still keep counting if you corrected a mistake Gaz -- gazornenplat ------------------------------------------------------------------------ gazornenplat's Profile: http://www.excelforum.com/member.php...o&userid=24494 View this thread: http://www.excelforum.com/showthread...hreadid=381054 |
All times are GMT +1. The time now is 03:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com