Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Soccer betting excel
Hi Guys,
Would appreciate a great help ... I am entrusted to make the excel sheet for the Bundesliga here for the only reason i come from India and i am supposed to know Programming. Well jokes apart ... the excel contains the dates of the game, who all betted for the game, and how did he / she bet at the end of the game day. Finally it would be something like an average as to who bet the most and who was the most successful. I counted the number of bets made by person but was unable to make a kind of an average and in the end who had the best average in making the bets. I can send in my excel file and explain accordingly ... i am totally confused as i have no idea of betting too Would sincerely appreciate all the help i can get Best Regards Shanker |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Soccer betting excel
You can easily get conditional average
=AVERAGE(IF(A1:A10="Frank",B1:B10)) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. column A is the punters, B is the bet. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message ups.com... Hi Guys, Would appreciate a great help ... I am entrusted to make the excel sheet for the Bundesliga here for the only reason i come from India and i am supposed to know Programming. Well jokes apart ... the excel contains the dates of the game, who all betted for the game, and how did he / she bet at the end of the game day. Finally it would be something like an average as to who bet the most and who was the most successful. I counted the number of bets made by person but was unable to make a kind of an average and in the end who had the best average in making the bets. I can send in my excel file and explain accordingly ... i am totally confused as i have no idea of betting too Would sincerely appreciate all the help i can get Best Regards Shanker |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |