Max Frequency w/ 2 criteria

[gtd526]

Hello,
Currently using =MAX(FREQUENCY(IF(A:A<>"", IF(A:A="W", ROW(A:A))), IF(A:A<>"", IF(A:A<>"W", ROW(A:A)))))
as an Array, which is working.
I'd like to add O:O = "Odd Ball" as a second criteria to count A:A="W".
Thank you.

 

[ExcelToDAX]

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

 

[gtd526]

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

Results of your formula is "0", which is incorrect.
Sample Data:

My Wagers.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
84	L	1/14		NBA	SPRD	$ 5.00	$ 4.35	GSW	MEM	-7	($5.00)	Orange - Q,S,V,X,AA		Away	Odd Ball
85	W			NBA	SPRD	$ 10.00	$ 9.09	PHI	HOU	-7.5	$9.09	Rank2, AD & AE >60%		Home	Odd Ball
86				NBA	SPRD	$ 5.00	$ 4.55
87				NBA	SPRD	$ 5.00	$ 4.55
88				NBA	SPRD	$ 5.00	$ 4.55
89				NBA	SPRD	$ 10.00	$ 9.10
90											$4.09
91			$84.54	Balance
92	W	1/15		NBA	SPRD	$ 10.00	$ 8.70	PHI	DEN	-4	$8.70	Rank2, AD & AE >60%		Home	Odd Ball
93				NBA	SPRD	$ 5.00	$ 4.55
94				NBA	SPRD	$ 5.00	$ 4.55
95				NBA	SPRD	$ 5.00	$ 4.55
96				NBA	SPRD	$ 5.00	$ 4.55
97				NBA	SPRD	$ 10.00	$ 9.10
98											$8.70
99			$93.24	Balance
100	W	1/17		NBA	SPRD	$ 10.00	$ 9.09	NOP	CHA	-11.5	$9.09	Rank2, AD & AE >60%	85.0%	Home	Odd Ball
101	W			NBA	SPRD	$ 10.00	$ 8.70	BOS	SAS	-16	$8.70	Rank2, AD & AE >60%	85.0%	Home	Odd Ball
102				NBA	SPRD	$ 10.00	$ 9.09
103				NBA	SPRD	$ 5.00	$ 4.55
104				NBA	SPRD	$ 5.00	$ 4.55
105				NBA	SPRD	$ 10.00	$ 9.10
106											$17.79
107			$111.03	Balance
108	L	1/17		NBA	SPRD	$ 5.00	$ 4.55	IND	POR	-5	($5.00)	Orange - Q,S,V,X,AA	75.0%	Away	Odd Ball
109	L			NBA	SPRD	$ 5.00	$ 4.55	NOP	PHO	-2	($5.00)	M,N>0, Q,R>0	61.9%	Home
110	L			NBA	SPRD	$ 10.00	$ 9.52	BOS	DEN	-6.5	($10.00)	Orange - Q,S,V,X,AA	75.0%	Home	Odd Ball
111				NBA	SPRD	$ 5.00	$ 4.55
112				NBA	SPRD	$ 5.00	$ 4.55
113				NBA	SPRD	$ 10.00	$ 9.10
114											($20.00)
115			$91.03	Balance
NBA

 

[gtd526]

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

I modified your formula as an Array to:
=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)))))
and its working correctly.
Thanks.