team standings
How would i make a table to keep track of win/loss totals?
|
Chris
Give us a little more than that. What do you want this table to look like? What data do you want in the table? What do you want the table to do for you? HTH Otto "Chris1" wrote in message ... How would i make a table to keep track of win/loss totals? |
How would i make a table to keep track of win/loss totals?
One way is illustrated by the CSV file below. --------------- cut here ----------------------- ,"=""8/22""","=""8/29""","=""9/5""","=""9/12""",,W,L Lions,W,W,,,,"=COUNTIF($B2:F2,G$1)","=COUNTIF($B2: G2,H$1)" Tigers,L,W,,,,"=COUNTIF($B3:F3,G$1)","=COUNTIF($B3 :G3,H$1)" Sharks,W,L,,,,"=COUNTIF($B4:F4,G$1)","=COUNTIF($B4 :G4,H$1)" Pumas,L,L,,,,"=COUNTIF($B5:F5,G$1)","=COUNTIF($B5: G5,H$1)" |
All times are GMT +1. The time now is 11:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com