New Posts For Thread: Can excel perform this taskhttps://community.betfair.com/general_betting/go/thread/view/94082/23482526/can-excel-perform-this-taskIf i have a list of football fixtures (the full season to date) in - oldest to newest date order descending down a columncan I find a way of say finding the last six games featuring say Melchester Rovers, and calculate their record for a current forFound out how to do it.I'm getting ok at this Excel malarkey and will only ask for help on here when i've exhausted all other avenues.Thanks to all the people who've helped me with stuff over the years and have got me to this point.https://community.betfair.com/general_betting/go/thread/view/94082/23482526/can-excel-perform-this-task?post_id=419440974#419440974Found out how to do it.I'm getting ok at this Excel malarkey and will only ask for help on here when i've exhausted all other avenues.Thanks to all the people who've helped me with stuff over the years and have got me to this point.Fri, 01 Jan 2010 09:16:08 -0600FK should read KR.https://community.betfair.com/general_betting/go/thread/view/94082/23482526/can-excel-perform-this-task?post_id=419440938#419440938FK should read KR.Fri, 01 Jan 2010 06:11:13 -0600I adopted a hybrid of FK's suggestion, I've just run into one small problem that's stopping me getting this fully solved.I have vlookup to look for all fixtures in the 12th round of gamesIf say Chelsea have only played 11, then it will return for rowhttps://community.betfair.com/general_betting/go/thread/view/94082/23482526/can-excel-perform-this-task?post_id=419440934#419440934I adopted a hybrid of FK's suggestion, I've just run into one small problem that's stopping me getting this fully solved.I have vlookup to look for all fixtures in the 12th round of gamesIf say Chelsea have only played 11, then it will return for rowFri, 01 Jan 2010 06:10:50 -0600Finally got round to this.That worked fine Knight Rider, I owe you a beer.https://community.betfair.com/general_betting/go/thread/view/94082/23482526/can-excel-perform-this-task?post_id=419440822#419440822Finally got round to this.That worked fine Knight Rider, I owe you a beer.Wed, 30 Dec 2009 16:23:07 -0600Cheers Knight Rider I'll have a play with that.https://community.betfair.com/general_betting/go/thread/view/94082/23482526/can-excel-perform-this-task?post_id=419440818#419440818Cheers Knight Rider I'll have a play with that.Wed, 23 Dec 2009 02:53:18 -0600It is probably easier in a database. (e.g. Access)You'd append the last 6 results for each team to a new table with a column for points. You'd then do a total of points for each team and then a query to sort the last 6 week league by descending pointhttps://community.betfair.com/general_betting/go/thread/view/94082/23482526/can-excel-perform-this-task?post_id=419440814#419440814It is probably easier in a database. (e.g. Access)You'd append the last 6 results for each team to a new table with a column for points. You'd then do a total of points for each team and then a query to sort the last 6 week league by descending pointWed, 23 Dec 2009 01:12:28 -0600You can create a new column with the Game # for each team. You can use a COUNTIF formula to work out the number of times the team appears in higher rows, then +1 to work out the game #.Then you can create another column giving a unique ID for each ghttps://community.betfair.com/general_betting/go/thread/view/94082/23482526/can-excel-perform-this-task?post_id=419440810#419440810You can create a new column with the Game # for each team. You can use a COUNTIF formula to work out the number of times the team appears in higher rows, then +1 to work out the game #.Then you can create another column giving a unique ID for each gWed, 23 Dec 2009 00:44:55 -0600Without using VBA you could try the following:Assuming you already have columns for Home team and Away team, add columns to your spreadsheet for Home points, Away points, Home goals and Away goals. Now cut and paste your Away team details directly behttps://community.betfair.com/general_betting/go/thread/view/94082/23482526/can-excel-perform-this-task?post_id=419440806#419440806Without using VBA you could try the following:Assuming you already have columns for Home team and Away team, add columns to your spreadsheet for Home points, Away points, Home goals and Away goals. Now cut and paste your Away team details directly beTue, 22 Dec 2009 15:57:52 -0600I'll put this on hold, I've a book coming on VBA.Will have a go once i've had a shufty through that.https://community.betfair.com/general_betting/go/thread/view/94082/23482526/can-excel-perform-this-task?post_id=419440802#419440802I'll put this on hold, I've a book coming on VBA.Will have a go once i've had a shufty through that.Tue, 22 Dec 2009 15:32:19 -0600http://en.wikipedia.org/wiki/Visual_Basic_for_Applicationshave funhttps://community.betfair.com/general_betting/go/thread/view/94082/23482526/can-excel-perform-this-task?post_id=419440798#419440798http://en.wikipedia.org/wiki/Visual_Basic_for_Applicationshave funTue, 22 Dec 2009 14:34:29 -0600