Hi .
I am wanting a formula that will count the number of consecutive sames values in a column that are together but not all of them in the column.
I have 365 rows and i want to be able to insert the formula in B1 and drag down to B365 so that the Value in B wil update as and when A changes.
<tbody>
</tbody>
The issue i am having is the not including the top 3 "Bob"'s with the bottom 4 Bob's
=IF(C1<>"",COUNTIF($A$1:A1,A1),"")
Drags down to :
=IF(C9<>"",COUNTIF($A$1:A9,A9),"")
With this my B9 number is 7
Thanks in advance.
P
I am wanting a formula that will count the number of consecutive sames values in a column that are together but not all of them in the column.
I have 365 rows and i want to be able to insert the formula in B1 and drag down to B365 so that the Value in B wil update as and when A changes.
A | B | C | |
1 | Bob | ||
2 | Bob | ||
3 | Bob | 3 | Leave |
4 | James | ||
5 | James | 2 | Leave |
6 | Bob | ||
7 | Bob | ||
8 | Bob | ||
9 | Bob | 4 | Leave |
<tbody>
</tbody>
The issue i am having is the not including the top 3 "Bob"'s with the bottom 4 Bob's
=IF(C1<>"",COUNTIF($A$1:A1,A1),"")
Drags down to :
=IF(C9<>"",COUNTIF($A$1:A9,A9),"")
With this my B9 number is 7
Thanks in advance.
P