Count Consecutive Cells from a starting point

[SyrEdu]

Hello. I am trying to have a formula that will count the number of consecutive cells using a starting point. I have used the threads to find the number of consecutive cells in a range but I only want to have the number of consecutive cells starting at the left most. Below is an example where i want to see the count of consecutive "A'"s starting at the left most cell Any help would be appreciated. Thanksssssss.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RESULT[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD][/TD]
[TD]C[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

 

[AlphaFrog]

This is an array formula. Confirm with Ctrl+Shift+Enter

=MIN(IF(A1:I1<>"A",COLUMN(A1:I1)-1,""))

 

[SyrEdu]

Works to perfection. Thank you so much. Maybe i won't be fired now thanks again

 

[AlphaFrog]

You're welcome. Thanks for the feedback.