New Posts For Thread: excel help pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/23482306/excel-help-pleaseI am trying to achieve the following, count the no. of t's and place the no. in the adjacent cell, resetting after each set of t's when a blank cell is encountered....basically to count the no. of t's between two blank cells...i am just learning exceplease follow this thread in the poker forumhttps://community.betfair.com/general_betting/go/thread/view/94082/23482306/excel-help-please?post_id=419438110#419438110please follow this thread in the poker forumMon, 28 Dec 2009 10:55:19 -0600compound i can't get your formula to work i get the followingA B AAt 1 1 t 2t 2 2 0 t 26 #VALUE! t #VALUE!t #VALUE!t 26 #VALUE! thttps://community.betfair.com/general_betting/go/thread/view/94082/23482306/excel-help-please?post_id=419438106#419438106compound i can't get your formula to work i get the followingA B AAt 1 1 t 2t 2 2 0 t 26 #VALUE! t #VALUE!t #VALUE!t 26 #VALUE! tMon, 28 Dec 2009 10:45:18 -0600thanks compound i have the solution....the problem i am having now is that i can't sum the numbers...it works if i type in the no.s but not when it is calculated...the sloution was given to me by jim in poker forumhttps://community.betfair.com/general_betting/go/thread/view/94082/23482306/excel-help-please?post_id=419438046#419438046thanks compound i have the solution....the problem i am having now is that i can't sum the numbers...it works if i type in the no.s but not when it is calculated...the sloution was given to me by jim in poker forumMon, 28 Dec 2009 08:49:31 -0600If you have excel 2007If your first t is in cell A2 do below, if it is not cell A2 the formulas will need adjusting!In column B next to your first t, copy and paste this formula~=IF(A3="",COUNTIFS(AA$2:AA$500,AA2,A$2:A$500,"t"),"")Fill down for as mahttps://community.betfair.com/general_betting/go/thread/view/94082/23482306/excel-help-please?post_id=419438038#419438038If you have excel 2007If your first t is in cell A2 do below, if it is not cell A2 the formulas will need adjusting!In column B next to your first t, copy and paste this formula~=IF(A3="",COUNTIFS(AA$2:AA$500,AA2,A$2:A$500,"t"),"")Fill down for as maMon, 28 Dec 2009 00:28:00 -0600thanks guys but may be i did not explain properly, i have the t's in the column and i want the no.s in the next coulmn to be put there by the formula applied to the t column....in other words the colums with no.s is the answer i am looking for..thankhttps://community.betfair.com/general_betting/go/thread/view/94082/23482306/excel-help-please?post_id=419438034#419438034thanks guys but may be i did not explain properly, i have the t's in the column and i want the no.s in the next coulmn to be put there by the formula applied to the t column....in other words the colums with no.s is the answer i am looking for..thankSun, 27 Dec 2009 16:38:51 -0600Not sure if this would work but you could try leaving a blank row at the top then drag this down from cell B2..=IF(A2="",0,B1+1)https://community.betfair.com/general_betting/go/thread/view/94082/23482306/excel-help-please?post_id=419438030#419438030Not sure if this would work but you could try leaving a blank row at the top then drag this down from cell B2..=IF(A2="",0,B1+1)Sun, 27 Dec 2009 10:18:25 -0600you need to use the countif functionhttps://community.betfair.com/general_betting/go/thread/view/94082/23482306/excel-help-please?post_id=419438026#419438026you need to use the countif functionSun, 27 Dec 2009 10:07:38 -0600I am trying to achieve the following, count the no. of t's and place the no. in the adjacent cell, resetting after each set of t's when a blank cell is encountered....basically to count the no. of t's between two blank cells...i am just learning excehttps://community.betfair.com/general_betting/go/thread/view/94082/23482306/excel-help-please?post_id=419438022#419438022I am trying to achieve the following, count the no. of t's and place the no. in the adjacent cell, resetting after each set of t's when a blank cell is encountered....basically to count the no. of t's between two blank cells...i am just learning exceSun, 27 Dec 2009 10:04:42 -0600