New Posts For Thread: newbie to excel, excel formula help pleasehttps://community.betfair.com/horse_racing/go/thread/view/94102/29919167/newbie-to-excel-excel-formula-help-pleasehi in excel I have column D that has runners,column J that has betfair prices, column AG my own rankings from my ratings, rankings top is 1 and bottom = number of runners column W the result of the formulaand I want to add to column W a formula thatno all the betfair odds are there,yes column J is actual lay odds and need to filter out the ones below 16.0 then the top priced 26.9%https://community.betfair.com/horse_racing/go/thread/view/94102/29919167/newbie-to-excel-excel-formula-help-please?post_id=532087903#532087903no all the betfair odds are there,yes column J is actual lay odds and need to filter out the ones below 16.0 then the top priced 26.9%Wed, 08 May 2013 07:04:47 -0500ok matehttps://community.betfair.com/horse_racing/go/thread/view/94102/29919167/newbie-to-excel-excel-formula-help-please?post_id=532087893#532087893ok mateWed, 08 May 2013 07:04:06 -0500not got actual rank just betfair prices which are ranked I supposesorry got to go now thanks once again for all your help, I have pm'd you with my email if you want the actual book to work withhttps://community.betfair.com/horse_racing/go/thread/view/94102/29919167/newbie-to-excel-excel-formula-help-please?post_id=532087875#532087875not got actual rank just betfair prices which are ranked I supposesorry got to go now thanks once again for all your help, I have pm'd you with my email if you want the actual book to work withWed, 08 May 2013 07:03:02 -0500or is column j the top 26.9 (actual) and then you need to filter out the odds you want ie less than 16?https://community.betfair.com/horse_racing/go/thread/view/94102/29919167/newbie-to-excel-excel-formula-help-please?post_id=532087867#532087867or is column j the top 26.9 (actual) and then you need to filter out the odds you want ie less than 16?Wed, 08 May 2013 07:02:54 -0500top 26.9 at odds of less than 16.0 ( column J )so in column j are the betfair odds already sorted so they are less than 16?https://community.betfair.com/horse_racing/go/thread/view/94102/29919167/newbie-to-excel-excel-formula-help-please?post_id=532087855#532087855top 26.9 at odds of less than 16.0 ( column J )so in column j are the betfair odds already sorted so they are less than 16?Wed, 08 May 2013 07:02:11 -0500no I don't compare I just use my ratings and compare against the odds, actual market is I that is the latest price,number of runners is in A43 but that changes with each racehttps://community.betfair.com/horse_racing/go/thread/view/94102/29919167/newbie-to-excel-excel-formula-help-please?post_id=532087823#532087823no I don't compare I just use my ratings and compare against the odds, actual market is I that is the latest price,number of runners is in A43 but that changes with each raceWed, 08 May 2013 07:01:02 -0500need this to be able to write the formula in whttps://community.betfair.com/horse_racing/go/thread/view/94102/29919167/newbie-to-excel-excel-formula-help-please?post_id=532087801#532087801need this to be able to write the formula in wWed, 08 May 2013 07:00:18 -0500in my table example i used i had 'my rank' and 'actual rank'where is actual rank in your datahttps://community.betfair.com/horse_racing/go/thread/view/94102/29919167/newbie-to-excel-excel-formula-help-please?post_id=532087795#532087795in my table example i used i had 'my rank' and 'actual rank'where is actual rank in your dataWed, 08 May 2013 06:59:36 -0500yes your rank is agwhere is the other percentage figure market rank/no of runnershttps://community.betfair.com/horse_racing/go/thread/view/94102/29919167/newbie-to-excel-excel-formula-help-please?post_id=532087783#532087783yes your rank is agwhere is the other percentage figure market rank/no of runnersWed, 08 May 2013 06:58:52 -0500you know you bet when your percentages are different to the actual market rank/runnersneed to compare the 2 so where is the actual market/no of runners in your sheet?https://community.betfair.com/horse_racing/go/thread/view/94102/29919167/newbie-to-excel-excel-formula-help-please?post_id=532087775#532087775you know you bet when your percentages are different to the actual market rank/runnersneed to compare the 2 so where is the actual market/no of runners in your sheet?Wed, 08 May 2013 06:58:10 -0500