General Betting
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: 7
|
By:
you need to use the countif function
|
|
By:
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) |
|
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:
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 |
|
By:
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
|
|
By:
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 |
|
By:
please follow this thread in the poker forum
|