count a consecutive cells with text over different rows / columns

[Ben9108]

I would like to solicit your help to resolve the below excel issue.
1. Writing a formula to count consecutive cells with text over different rows/columns
2. The successful formula to count consecutive cells with text in single row/ column is shown below, how to write a formula to do the same thing over huge different rows/ columns?

W: Maximum consecutive cells counting from B3: R5
L: Maximum consecutive cells counting from B3: R5
E: Maximum consecutive cells counting from B3: R5
R: Maximum consecutive cells counting from B3: R5
S: Maximum consecutive cells counting from B3: R5
V: Maximum consecutive cells counting from B3: R5
N: Maximum consecutive cells counting from B3: R5

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

3

W

W

W

@

L

L

L

@

W

W

W

W

@

N

N

N

N

4

E

E

E

@

R

R

R

@

E

E

W

W

@

L

L

L

L

5

S

S

S

@

V

V

V

@

N

N

V

W

@

W

S

S

S

<tbody>
</tbody>

Formula to count a consecutive cells with text in single row/ column =MAX(FREQUENCY(IF(B3:R3="W",COLUMN(B3:R3)),IF(B3:R3<>"W",COLUMN(B3:R3))))
Answer for the formula is 4

 

[pgc01]

Hi

Do the lines wrap? Meaning, is row 4 the continuation of row 3 or each row should be processed individually?

Ex.:

Let's say that in your example B4="N".

In this case would we have

- 4 consecutive "N" in row 3 + 1 "N" in row 4

or

- 5 consecutive "N", because row 4 is the continuation of row 3

?