New Posts For Thread: Excel Questionhttps://community.betfair.com/general_betting/go/thread/view/94082/23531690/excel-questionhow is it possible to count how many time a cell changes value please? i.e if A1 changes five times then A2 would = 5.nice, thankshttps://community.betfair.com/general_betting/go/thread/view/94082/23531690/excel-question?post_id=420811690#420811690nice, thanksThu, 11 Mar 2010 11:49:38 -0600http://excel.brainbell.com/an excellent site that forum name Triggerster gave me yesterday, bookmark and look through it when you have time , great infohttps://community.betfair.com/general_betting/go/thread/view/94082/23531690/excel-question?post_id=420811686#420811686http://excel.brainbell.com/an excellent site that forum name Triggerster gave me yesterday, bookmark and look through it when you have time , great infoThu, 11 Mar 2010 11:24:27 -0600Is there an easy way to see what profit I've made from one type of bet?Can you arrange so you can see if you've done well by backing 0-0's for example?I've downloaded the history into excel but I'm not sure how to use it :(https://community.betfair.com/general_betting/go/thread/view/94082/23531690/excel-question?post_id=420811682#420811682Is there an easy way to see what profit I've made from one type of bet?Can you arrange so you can see if you've done well by backing 0-0's for example?I've downloaded the history into excel but I'm not sure how to use it :(Thu, 11 Mar 2010 11:17:18 -0600Private Sub Worksheet_Change(ByVal Target As Range)For i = 1 To 3If Target.Row = i And Target.Column = 1 ThenCells(i, 2) = Cells(i, 2) + 1End IfNext iEnd SubThe above code works fine when changing the cells manually, however if linked to gruss nothinhttps://community.betfair.com/general_betting/go/thread/view/94082/23531690/excel-question?post_id=420811674#420811674Private Sub Worksheet_Change(ByVal Target As Range)For i = 1 To 3If Target.Row = i And Target.Column = 1 ThenCells(i, 2) = Cells(i, 2) + 1End IfNext iEnd SubThe above code works fine when changing the cells manually, however if linked to gruss nothinThu, 11 Mar 2010 08:31:18 -0600Wrong Hole Poker imlacs code will increase count if the same value is entered in the cell I just added a For loop to it t show how to include ForIf you're entering data manually that'd be ok but if data is being entered automated and the same value ihttps://community.betfair.com/general_betting/go/thread/view/94082/23531690/excel-question?post_id=420811542#420811542Wrong Hole Poker imlacs code will increase count if the same value is entered in the cell I just added a For loop to it t show how to include ForIf you're entering data manually that'd be ok but if data is being entered automated and the same value iTue, 09 Mar 2010 14:26:38 -0600works a treat Ghetto Joe nice one ;)https://community.betfair.com/general_betting/go/thread/view/94082/23531690/excel-question?post_id=420811538#420811538works a treat Ghetto Joe nice one ;)Tue, 09 Mar 2010 14:12:10 -0600yep cheers ghetto Joe, thanks for your timehttps://community.betfair.com/general_betting/go/thread/view/94082/23531690/excel-question?post_id=420811534#420811534yep cheers ghetto Joe, thanks for your timeTue, 09 Mar 2010 14:10:18 -0600yes you can keep track of previous odds changes, I'm assuming your using gruss?you just include stuff like For i = 5 To 35Cells(i, 27) = Cells(i, 15)Next iwithin your code and that would copy the contents of F5:F40 (last price matched) into AA5:AA40thttps://community.betfair.com/general_betting/go/thread/view/94082/23531690/excel-question?post_id=420811530#420811530yes you can keep track of previous odds changes, I'm assuming your using gruss?you just include stuff like For i = 5 To 35Cells(i, 27) = Cells(i, 15)Next iwithin your code and that would copy the contents of F5:F40 (last price matched) into AA5:AA40tTue, 09 Mar 2010 14:08:58 -0600quick question re your formula posted @ 19.53 Ghetto Joe,is it possible to display the five different values that where in a cell in a new column of data?Thankshttps://community.betfair.com/general_betting/go/thread/view/94082/23531690/excel-question?post_id=420811526#420811526quick question re your formula posted @ 19.53 Ghetto Joe,is it possible to display the five different values that where in a cell in a new column of data?ThanksTue, 09 Mar 2010 13:54:11 -0600Couldn't get your code to work on my version of excel but using imlac's codePrivate Sub Worksheet_Change(ByVal Target As Range)For i = 1 To 3If Target.Row = i And Target.Column = 1 ThenCells(i, 2) = Cells(i, 2) + 1End IfNext iEnd Subhttps://community.betfair.com/general_betting/go/thread/view/94082/23531690/excel-question?post_id=420811522#420811522Couldn't get your code to work on my version of excel but using imlac's codePrivate Sub Worksheet_Change(ByVal Target As Range)For i = 1 To 3If Target.Row = i And Target.Column = 1 ThenCells(i, 2) = Cells(i, 2) + 1End IfNext iEnd SubTue, 09 Mar 2010 13:48:54 -0600