Home |
Search |
Today's Posts |
#1
|
|||
|
|||
team standings
How would i make a table to keep track of win/loss totals?
|
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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)" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort list of players by team from player list on separate sheet | Excel Worksheet Functions | |||
softball standings | Excel Discussion (Misc queries) | |||
Highest score in team | Excel Discussion (Misc queries) | |||
Barb Reinhardt: HOW TO: Plot a Team Name .... | Charts and Charting in Excel | |||
HOW TO: Plot a Team Name on a chart based on two values | Charts and Charting in Excel |