Exchange Games
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
sort by:
Show
per page
Replies: 8
|
By:
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 |
|
By:
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 |
|
By:
Try the formula .
It will do what you want. |
|
By:
it just puts a 1 opposite a t and not the subtotal...eg eg 2 t's in a row =2 etc
|
|
By:
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. |
|
By:
i stand corrected...thank you
|
|
By:
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
|
|
By:
please follow this thread in the poker forum to contribute....thank you
|