General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
I 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 excel...any help would much appreciated
t 1
t
t 2
t 1
t
t
t 3
t 1
t
t
t
t 4
thanking in anticipation
t 1
t
t 2
t 1
t
t
t 3
t 1
t
t
t
t 4
thanking in anticipation
Show More
Not 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)
=IF(A2="",0,B1+1)
thanks 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..
thanks again
thanks again
If you have excel 2007
If 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 many rows that have a t in them
In cell AA2 enter a 1
In cell AA3 copy and paste this formula~
=IF($A3="","",IF(AND($A3="t",A2=""),AA1+1,AA2))
Fill down for as many rows that have a t in them
COUNTIFS will not work in excel prior to excel 2007
If 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 many rows that have a t in them
In cell AA2 enter a 1
In cell AA3 copy and paste this formula~
=IF($A3="","",IF(AND($A3="t",A2=""),AA1+1,AA2))
Fill down for as many rows that have a t in them
COUNTIFS will not work in excel prior to excel 2007
thanks 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 forum
compound i can't get your formula to work i get the following
A B AA
t 1 1
t 2
t 2 2
0
t 26 #VALUE!
t #VALUE!
t #VALUE!
t 26 #VALUE!
t 26 #VALUE!
0
0
t #VALUE!
t #VALUE!
t #VALUE!
t 26 #VALUE!
0
t 26 #VALUE!
0
t 26 #VALUE!
0
t 26 #VALUE!
0
t #VALUE!
t #VALUE!
t 26 #VALUE!
t #VALUE!
t 26 #VALUE!
0
t #VALUE!
t #VALUE!
t #VALUE!
t #VALUE!
t 26 #VALUE!
t #VALUE!
t #VALUE!
t #VALUE!
t 26 #VALUE!
could you have look please
A B AA
t 1 1
t 2
t 2 2
0
t 26 #VALUE!
t #VALUE!
t #VALUE!
t 26 #VALUE!
t 26 #VALUE!
0
0
t #VALUE!
t #VALUE!
t #VALUE!
t 26 #VALUE!
0
t 26 #VALUE!
0
t 26 #VALUE!
0
t 26 #VALUE!
0
t #VALUE!
t #VALUE!
t 26 #VALUE!
t #VALUE!
t 26 #VALUE!
0
t #VALUE!
t #VALUE!
t #VALUE!
t #VALUE!
t 26 #VALUE!
t #VALUE!
t #VALUE!
t #VALUE!
t 26 #VALUE!
could you have look please
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539