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

General Betting

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 help please
Show More
Loading...
Report lumponlarge • December 27, 2009 4:07 PM GMT
you need to use the countif function
Report Pleasegivemeanailedontip • December 27, 2009 4:18 PM GMT
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)
Report poker player • December 27, 2009 10:38 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 Compound Magic • December 28, 2009 6:28 AM GMT
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
Report poker player • December 28, 2009 2:49 PM GMT
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
Report poker player • December 28, 2009 4:45 PM GMT
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
Report poker player • December 28, 2009 4:55 PM GMT
please follow this thread in the poker forum
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.

Wonder

Instance ID: 13539
www.betfair.com