New Posts For Thread: Excel help plshttps://community.betfair.com/general_betting/go/thread/view/94082/23535246/excel-help-plsI've got a colum with 5 possible entries:0,0.5,1,-0.5,-1How do I count the number of instances of each one in separate cells please?good stuff Pinza! no doubt will need that in the futurehttps://community.betfair.com/general_betting/go/thread/view/94082/23535246/excel-help-pls?post_id=420925034#420925034good stuff Pinza! no doubt will need that in the futureWed, 24 Mar 2010 01:07:23 -0500Get the wizard upclick on "other" and use key on the left next to shiftwhich will give you | That has sorted out the data in all the cellshttps://community.betfair.com/general_betting/go/thread/view/94082/23535246/excel-help-pls?post_id=420924990#420924990Get the wizard upclick on "other" and use key on the left next to shiftwhich will give you | That has sorted out the data in all the cellsTue, 23 Mar 2010 16:25:49 -0500Thanks guys.https://community.betfair.com/general_betting/go/thread/view/94082/23535246/excel-help-pls?post_id=420924830#420924830Thanks guys.Mon, 22 Mar 2010 09:15:18 -0500+ maybe just give them a call? the tech guy on interactive seems reasonably helpfulhttps://community.betfair.com/general_betting/go/thread/view/94082/23535246/excel-help-pls?post_id=420924826#420924826+ maybe just give them a call? the tech guy on interactive seems reasonably helpfulSun, 21 Mar 2010 15:55:54 -0500Pinza, not sure if it applies in your case if you're using Interactive, but i know RP data downloads into one cell when using Internet Explorer, and into separate cells with Firefox.https://community.betfair.com/general_betting/go/thread/view/94082/23535246/excel-help-pls?post_id=420924822#420924822Pinza, not sure if it applies in your case if you're using Interactive, but i know RP data downloads into one cell when using Internet Explorer, and into separate cells with Firefox.Sun, 21 Mar 2010 15:17:14 -0500I managed to sort some stuff recently using FIND,LEN and LEFT. It was messy and I'm not sure I could even do it again without a lot of thought, but googling those three might help.Google show all text to the left of a symbol in excel and things alonghttps://community.betfair.com/general_betting/go/thread/view/94082/23535246/excel-help-pls?post_id=420924818#420924818I managed to sort some stuff recently using FIND,LEN and LEFT. It was messy and I'm not sure I could even do it again without a lot of thought, but googling those three might help.Google show all text to the left of a symbol in excel and things alongSun, 21 Mar 2010 15:03:30 -0500Raceform data downloaded into excel and all data in one cell.Used to do it with wizard and use ' delimiter but that doesn't seem to workTried splitting the cells with "Text to Columns" but cells still overlap with various data.Any suggestionshttps://community.betfair.com/general_betting/go/thread/view/94082/23535246/excel-help-pls?post_id=420924814#420924814Raceform data downloaded into excel and all data in one cell.Used to do it with wizard and use ' delimiter but that doesn't seem to workTried splitting the cells with "Text to Columns" but cells still overlap with various data.Any suggestionsSun, 21 Mar 2010 14:41:38 -0500not a problemhttps://community.betfair.com/general_betting/go/thread/view/94082/23535246/excel-help-pls?post_id=420924810#420924810not a problemSun, 21 Mar 2010 11:04:59 -0500sorted, cheershttps://community.betfair.com/general_betting/go/thread/view/94082/23535246/excel-help-pls?post_id=420924806#420924806sorted, cheersSun, 21 Mar 2010 03:03:19 -0500will do tahttps://community.betfair.com/general_betting/go/thread/view/94082/23535246/excel-help-pls?post_id=420924802#420924802will do taSun, 21 Mar 2010 02:57:34 -0500