New Posts For Thread: Open Office spreadsheet help pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/26245833/open-office-spreadsheet-help-pleaseWhenever I download a list of horses I'm interested in from the site I use, I'm presented with a spreadsheet that looks like this....... slot systemname horse_name race_time track odds_numerical 2Thanks C M I'll give it a whirl.https://community.betfair.com/general_betting/go/thread/view/94082/26245833/open-office-spreadsheet-help-please?post_id=473938077#473938077Thanks C M I'll give it a whirl.Fri, 12 Nov 2010 07:50:41 -0600In fact a macro could do it all for you including putting in the vlookup.After doing your download it would mean just running the macro which would take only a second to do it all.https://community.betfair.com/general_betting/go/thread/view/94082/26245833/open-office-spreadsheet-help-please?post_id=473937841#473937841In fact a macro could do it all for you including putting in the vlookup.After doing your download it would mean just running the macro which would take only a second to do it all.Fri, 12 Nov 2010 07:48:49 -0600Hi top2ratedNot positive of what you require but my guess would go like this ~First select your total data area then in the name box type datum then press enterIn a column next to your points uses SUMPRODUCT(....) (because there is no SUMIFS in openhttps://community.betfair.com/general_betting/go/thread/view/94082/26245833/open-office-spreadsheet-help-please?post_id=473935873#473935873Hi top2ratedNot positive of what you require but my guess would go like this ~First select your total data area then in the name box type datum then press enterIn a column next to your points uses SUMPRODUCT(....) (because there is no SUMIFS in openFri, 12 Nov 2010 07:30:47 -0600Whenever I download a list of horses I'm interested in from the site I use, I'm presented with a spreadsheet that looks like this....... slot systemname horse_name race_time track odds_numerical 2https://community.betfair.com/general_betting/go/thread/view/94082/26245833/open-office-spreadsheet-help-please?post_id=473926129#473926129Whenever I download a list of horses I'm interested in from the site I use, I'm presented with a spreadsheet that looks like this....... slot systemname horse_name race_time track odds_numerical 2Fri, 12 Nov 2010 05:32:52 -0600