Exchange Games
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
If the t's appear in column A and the count in column B, then simply enter the following formula into cell B2 and copy it down column B,
= if ( a2="t", b1+1,0)
Obviously you should start with blank cells in row 1
= if ( a2="t", b1+1,0)
Obviously you should start with blank cells in row 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
Try the formula .
It will do what you want.
It will do what you want.
it just puts a 1 opposite a t and not the subtotal...eg eg 2 t's in a row =2 etc
No it doesn't.
Can't help you anymore as you don't seem to be able to grasp the basics of writing a formula.
eg the formula will give you 1 if there is a " t " in row 2 and will give you 2 if there is another in row 3 etc etc.
Can't help you anymore as you don't seem to be able to grasp the basics of writing a formula.
eg the formula will give you 1 if there is a " t " in row 2 and will give you 2 if there is another in row 3 etc etc.
hello fine as frog.....i have been given the solution in poker forum however i am trying to do a sum of the numbers in the column but it won't work whereas if i type in the no.s in a separate column and use the sum function it works fine...any advice welcome....please be gentle as I have only started using excel recently and learning as i go along...thank you
please follow this thread in the poker forum to contribute....thank you
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539