#1   Report Post  
Chris1
 
Posts: n/a
Default team standings

How would i make a table to keep track of win/loss totals?
  #2   Report Post  
Otto Moehrbach
 
Posts: n/a
Default

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   Report Post  
Jay
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sort list of players by team from player list on separate sheet Robert Excel Worksheet Functions 1 July 19th 05 01:57 AM
softball standings randyrestg Excel Discussion (Misc queries) 1 June 22nd 05 12:38 AM
Highest score in team Hugh Murfitt Excel Discussion (Misc queries) 4 June 17th 05 02:09 AM
Barb Reinhardt: HOW TO: Plot a Team Name .... Kevin McCartney Charts and Charting in Excel 2 December 1st 04 01:28 PM
HOW TO: Plot a Team Name on a chart based on two values Kevin McCartney Charts and Charting in Excel 1 November 30th 04 05:26 PM


All times are GMT +1. The time now is 01:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"