New Posts For Thread: Excel Spreadsheet Question

Just seen this. How about putting =SIGN(F1-G1) in column H It will return 1,0 or -1 meaning fav won ,Joint Favs or Fav lost.This will make further processing simpler

Wed, 21 Dec 2011 07:24:36 -0600

Just seen this. How about putting =SIGN(F1-G1) in column H It will return 1,0 or -1 meaning fav won ,Joint Favs or Fav lost.This will make further processing simpler

fear not betfair, for we all code for the same thing and for the same reasons.

Sat, 17 Dec 2011 11:32:49 -0600

fear not betfair, for we all code for the same thing and for the same reasons.

yep thats another way to do it stoat40, shame there isnt a programming department on this forum asits needed and the developers forum isn't really a live environment as its based on some few projects that seem to be gathering dust in betfairs archive

Sat, 17 Dec 2011 11:31:43 -0600

yep thats another way to do it stoat40, shame there isnt a programming department on this forum asits needed and the developers forum isn't really a live environment as its based on some few projects that seem to be gathering dust in betfairs archive

Another way.Add a column H (or wherever), and insert formula to subtract losers from winners eg. =f-g. The formula you can then use is:=COUNTIF(h2:h2500,">0")

Fri, 16 Dec 2011 17:05:21 -0600

Another way.Add a column H (or wherever), and insert formula to subtract losers from winners eg. =f-g. The formula you can then use is:=COUNTIF(h2:h2500,">0")

< >http://chexed.com/ComputerTips/asciicodes.phpAlt60 for

Fri, 16 Dec 2011 13:49:15 -0600

< >http://chexed.com/ComputerTips/asciicodes.phpAlt60 for

grr what's up with this forum :(=IF(F2[b]

Fri, 16 Dec 2011 12:48:35 -0600

grr what's up with this forum :(=IF(F2[b]

bf_fanatic, thanks for guidance, will try soon and let you know how it goes but have to log off now and if it doesn't work - it's a lesson for 2012, wok it out manually as I go along - which obviously should have occurred to me in the first place - s

Fri, 16 Dec 2011 12:47:02 -0600

bf_fanatic, thanks for guidance, will try soon and let you know how it goes but have to log off now and if it doesn't work - it's a lesson for 2012, wok it out manually as I go along - which obviously should have occurred to me in the first place - s

=IF(F1

Fri, 16 Dec 2011 12:47:01 -0600

=IF(F1

Just do what bf said , in cell H do do a simple if statement to put 1 in the cell if F is less than G then simply do a sum of column H for the number of winning favs=IF(F2

Fri, 16 Dec 2011 12:46:14 -0600

Just do what bf said , in cell H do do a simple if statement to put 1 in the cell if F is less than G then simply do a sum of column H for the number of winning favs=IF(F2

nearly all good programming involves using the simplest long term solution.

Fri, 16 Dec 2011 12:42:11 -0600

nearly all good programming involves using the simplest long term solution.