Count consecutive value

[gtd526]

Hello,
How to count the most consecutive "W"s and "L"s in column A, 2 separate cells.
Column A:A will contain only "W"s and "L"s. And the range will continually move down.
There could be more than 1 result, depending on how many games are bet on that day.
Im only giving you a small range, this is the latest range.

Thanks

My Wagers.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
260	W	2/29		NBA	SPRD	$ 5.00	$ 4.55	NOP	IND	-5.5	$4.55	R, S, T>0, AL:AM >= 60%
261				NBA	SPRD	$ 5.00	$ 4.55
262				NBA	SPRD	$ 5.00	$ 4.55
263				NBA	SPRD	$ 5.00	$ 4.55
264				NBA	SPRD	$ 5.00	$ 4.55
265				NBA	SPRD	$ 10.00	$ 9.10
266											$4.55
267			$97.31	Balance
268	W	3/1		NBA	SPRD	$ 5.00	$ 4.76	ORL	DET	-10.5	$4.76	R, S, T>0, AL:AM >= 60%
269				NBA	SPRD	$ 5.00	$ 4.55
270				NBA	SPRD	$ 5.00	$ 4.55
271				NBA	SPRD	$ 5.00	$ 4.55
272				NBA	SPRD	$ 5.00	$ 4.55
273				NBA	SPRD	$ 10.00	$ 9.10
274											$4.76
275			$102.07	Balance
276	W	3/3		NBA	SPRD	$ 10.00	$ 9.09	HOU	SAS	-7.5	$9.09	R, S, T>0, AL:AM>=60%
277				NBA	SPRD	$ 5.00	$ 4.55
278				NBA	SPRD	$ 5.00	$ 4.55
279				NBA	SPRD	$ 5.00	$ 4.55
280				NBA	SPRD	$ 5.00	$ 4.55
281				NBA	SPRD	$ 10.00	$ 9.10
282											$9.09
283			$111.16	Balance
284		3/5		NBA	SPRD	$ 10.00	$ 8.70	OKC	MIA	-8.5	($10.00)	R, S, T>0, AL:AM>=60%
285				NBA	SPRD	$ 5.00	$ 4.55
286				NBA	SPRD	$ 5.00	$ 4.55
287				NBA	SPRD	$ 5.00	$ 4.55
288				NBA	SPRD	$ 5.00	$ 4.55
289				NBA	SPRD	$ 10.00	$ 9.10
290											($10.00)
291			$101.16	Balance
NBA

Cell Formulas
Range	Formula
H284:H289	H284	=IFERROR(LOOKUP(2, 1/((COUNTIF($H$283:$H283, [NBA.xlsm]Favs!$I$4:$I$33)=0)*([NBA.xlsm]Favs!$I$4:$I$33<>"")), [NBA.xlsm]Favs!$I$4:$I$33),"")
I284:I289	I284	=IFERROR(IF(1=MOD(MATCH($H284,[NBA.xlsm]Favs!$A$4:$A$33,0),2),INDEX([NBA.xlsm]Favs!$A$4:$A$33,MATCH(H284,[NBA.xlsm]Favs!$A$4:$A$33,0)+1),INDEX([NBA.xlsm]Favs!$A$4:$A$33,MATCH(H284,[NBA.xlsm]Favs!$A$4:$A$33,0)-1)),"")
J284:J289	J284	=IFERROR(INDEX([NBA.xlsm]Favs!$B$4:$B$33,MATCH($H284,[NBA.xlsm]Favs!$A$4:$A$33,FALSE)),"")
A284:A289	A284	=IFERROR(INDEX([NBA.xlsm]Favs!$C$4:$C$33,MATCH($H284,[NBA.xlsm]Favs!$A$4:$A$33,FALSE)),"")
L284:L289	L284	=IFERROR(INDEX([NBA.xlsm]Favs!$H$4:$H$33,MATCH($H284,[NBA.xlsm]Favs!$A$4:$A$33,FALSE)),"")
K284:K289	K284	=IF($H284="","",(IF($A284="W",$G284,IF($A284="L",$F284*-1,IF($A284="Psh",0,IF(ISNUMBER(J284),$F284*-1,))))))
K290	K290	=SUM(K284:K289)
C291	C291	=IF(AND(LOOKUP(2,1/(Chart!F:F<>""),Chart!F:F)="NBA",INDEX(Chart!F:F,LARGE(IF(Chart!F:F<>"",ROW(Chart!F:F)),2))="NFL"),INDEX(NFL!C:C,LARGE(IF(NFL!C:C<>"",ROW(NFL!C:C)),2))+LOOKUP(2,1/(NBA!K:K<>""),NBA!K:K),$C283+$K290)
Press CTRL+SHIFT+ENTER to enter array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G284:G289	Cell Value	="W"	text	NO
G284:G289	Cell Value	="L"	text	NO
G276:G281	Cell Value	="W"	text	NO
G276:G281	Cell Value	="L"	text	NO
G268:G273	Cell Value	="W"	text	NO
G268:G273	Cell Value	="L"	text	NO
G260:G265	Cell Value	="W"	text	NO
G260:G265	Cell Value	="L"	text	NO
O359:O360,A307:A1048576,A1:A296	Cell Value	="W"	text	NO
K:K	Cell Value	<0	text	NO
K:K	Cell Value	>0	text	NO
P5:P11,P13:P19,P21:P27,P29:P35,P37:P43,P45:P51,P53:P59,P61:P67,P69:P75,P77:P83,P85:P91,P93:P99,P101:P107,P109:P115,P117:P123,P125:P131,P133:P139,P141:P147,P149:P155,P157:P163,P165:P171,P173:P179,P181:P187,P189:P195,P197:P203,P205:P211,P213:P219,P221:P227	Cell Value	<0.525	text	NO
O359:O360,A307:A1048576,A1:A296	Cell Value	="L"	text	NO
O359:O360,A307:A1048576,A1:A296	Cell Value	="PSH"	text	NO

 

[Cubist]

I don't have 2019 to test but maybe this?

=MAX(FREQUENCY(IF(A:A<>"", IF(A:A="W", ROW(A:A))), IF(A:A<>"", IF(A:A<>"W", ROW(A:A)))))

 

[gtd526]

I don't have 2019 to test but maybe this?

=MAX(FREQUENCY(IF(A:A<>"", IF(A:A="W", ROW(A:A))), IF(A:A<>"", IF(A:A<>"W", ROW(A:A)))))

Perfect, I use it as an Array. Thank you.

 

[gtd526]

I don't have 2019 to test but maybe this?

=MAX(FREQUENCY(IF(A:A<>"", IF(A:A="W", ROW(A:A))), IF(A:A<>"", IF(A:A<>"W", ROW(A:A)))))

Your formula is working well!
how can I add an additional criteria to your existing formula, such as O:O = "Odd Ball"?
thank you

 

[Cubist]

Try:

=MAX(FREQUENCY(IF((A:A<>"")*(O:O="Odd Ball"), IF(A:A="W", ROW(A:A))), IF((A:A<>"")*(O:O="Odd Ball"), IF(A:A<>"W", ROW(A:A)))))

 

[gtd526]

Try:

=MAX(FREQUENCY(IF((A:A<>"")*(O:O="Odd Ball"), IF(A:A="W", ROW(A:A))), IF((A:A<>"")*(O:O="Odd Ball"), IF(A:A<>"W", ROW(A:A)))))

Thank you for the update. Its Working