Calculate Win (W) Streak in Only One Column Question

[MXL]

hello,

I would like to know if there is a formula to calculate the "win" streak in one column. I will show example below;

Longest Win Streak

W

W

L

W

W

W

3

In this column, you can see the longest W streak is 3, how could I put this in a formula for just this one column?

 

[Marcelo Branco]

Maybe

Pasta1
	A
1	Longest Win Streak
2	W
3	W
4	L
5	W
6	W
7	W
8	3
Plan2

Cell Formulas
Range	Formula
A8	A8	=MAX(FREQUENCY(IF($A$2:$A$7="W",ROW($A$2:$A$7)),IF($A$2:$A$7<>"W",ROW($A$2:$A$7))))
Press CTRL+SHIFT+ENTER to enter array formulas.

M.

 

[MXL]

thank you Marcelo, genius! works great!

 

[Marcelo Branco]

You're welcome. Glad to help.

M.