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
<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
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