Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
add up winning teams
Hi
I don't know how to word this so it makes a lot of sense so I'm just going to give it a go. we have a football tipping competition at work, we are using excel to keep track of it, a column for the betters, a column for each of the 8 rounds, a totals column and a year to date total column. we highlight the winning team so we can see them but is there a way that we can determine, without manually having to count up all the weeks and each team, that we can see which team has one the most, which one the least and how many each team has lost and won, sort of like an auto sum for words instead of numbers determined by the colour of the cell?? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
add up winning teams
You would need to use as mixture of index(match & max & min functions, it would be a lot easier to see the workbook and help you directly with that. sonia;320881 Wrote: Hi I don't know how to word this so it makes a lot of sense so I'm just going to give it a go. we have a football tipping competition at work, we are using excel to keep track of it, a column for the betters, a column for each of the 8 rounds, a totals column and a year to date total column. we highlight the winning team so we can see them but is there a way that we can determine, without manually having to count up all the weeks and each team, that we can see which team has one the most, which one the least and how many each team has lost and won, sort of like an auto sum for words instead of numbers determined by the colour of the cell?? Thanks -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=89696 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum different sized (employee) teams | Excel Worksheet Functions | |||
Bowling: Handicap between Teams | Excel Worksheet Functions | |||
Does any one have a Golf Tournament spreadsheet for teams? | Excel Discussion (Misc queries) | |||
transfering numbers into teams | Excel Worksheet Functions | |||
Winning Streak | Excel Worksheet Functions |