Forums

We want to share an important update with our Betfair Community users.

Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.

Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.

To share your feedback and experience, visit: https://support.betfair.com/app/home

Exchange Games

Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
poker player
27 Dec 09 16:04
Joined:
Date Joined: 03 Jul 03
| Topic/replies: 394 | Blogger: poker player's blog
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
Pause • Switch to Standard View excel hekp please
Show More
Loading...
Report FINE AS FROG HAIR • December 27, 2009 6:59 PM GMT
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
Report poker player • December 27, 2009 10:42 PM GMT
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
Report FINE AS FROG HAIR • December 27, 2009 11:00 PM GMT
Try the formula .
It will do what you want.
Report poker player • December 27, 2009 11:07 PM GMT
it just puts a 1 opposite a t and not the subtotal...eg eg 2 t's in a row =2 etc
Report FINE AS FROG HAIR • December 28, 2009 7:58 AM GMT
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.
Report poker player • December 28, 2009 2:55 PM GMT
i stand corrected...thank you
Report poker player • December 28, 2009 3:14 PM GMT
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
Report poker player • December 28, 2009 4:54 PM GMT
please follow this thread in the poker forum to contribute....thank you
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.

Wonder

Instance ID: 13539
www.betfair.com