Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Creating a league table based on results
How can I create a league table based on results. I want it to look like the picture and the statistics to be updated by functions offcourse. :-) +-------------------------------------------------------------------+ |Filename: Snap1_2.jpg | |Download: http://www.excelforum.com/attachment.php?postid=3995 | +-------------------------------------------------------------------+ -- gpktm ------------------------------------------------------------------------ gpktm's Profile: http://www.excelforum.com/member.php...o&userid=17538 View this thread: http://www.excelforum.com/showthread...hreadid=482532 |
#2
|
|||
|
|||
Creating a league table based on results
Try the following...
Games: H4, copied down: =COUNTIF($B$3:$C$8,G4) Wins: I4, copied down: =SUMPRODUCT((($B$3:$B$8=G4)*($D$3:$D$8$E$3:$E$8)) +(($C$3:$C$8=G4)*($E$3: $E$8$D$3:$D$8))) Losses: J4, copied down: =SUMPRODUCT((($B$3:$B$8=G4)*($D$3:$D$8<$E$3:$E$8)) +(($C$3:$C$8=G4)*($E$3: $E$8<$D$3:$D$8))) Hope this helps! In article , gpktm wrote: How can I create a league table based on results. I want it to look like the picture and the statistics to be updated by functions offcourse. :-) +-------------------------------------------------------------------+ |Filename: Snap1_2.jpg | |Download: http://www.excelforum.com/attachment.php?postid=3995 | +-------------------------------------------------------------------+ |
#3
|
|||
|
|||
Creating a league table based on results
Thanks, that helped some bit but there are some problems in the following: It not accepts the function in H4 cell. And how about the draws? -- gpktm ------------------------------------------------------------------------ gpktm's Profile: http://www.excelforum.com/member.php...o&userid=17538 View this thread: http://www.excelforum.com/showthread...hreadid=482532 |
#4
|
|||
|
|||
Creating a league table based on results
In article ,
gpktm wrote: It not accepts the function in H4 cell. That's probably because your version of Excel uses a semi-colon as a separator instead of a comma. Try... =COUNTIF($B$3:$C$8;G4) And how about the draws? =SUMPRODUCT((($B$3:$B$8=G4)*($D$3:$D$8=$E$3:$E$8)) +(($C$3:$C$8=G4)*($E$3: $E$8=$D$3:$D$8))) Hope this helps! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating single lines of data from a multi-column table | Excel Discussion (Misc queries) | |||
Creating a list from Table Data | Excel Worksheet Functions | |||
I am having problems creating pivot table of data | Charts and Charting in Excel | |||
Creating a Table | Excel Worksheet Functions | |||
Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) |