Multiple criteria

[Shree1]

I have a data set that looks like the below

MATCH_ID</SPAN>	SUM ID</SPAN>	CP</SPAN>
473132746</SPAN>	698131</SPAN>	A</SPAN>
473132746</SPAN>	459759729</SPAN>	B</SPAN>
473132746</SPAN>	459759732</SPAN>	B</SPAN>
473132748</SPAN>	698153</SPAN>	A</SPAN>
473132748</SPAN>	175466963</SPAN>	B</SPAN>
473132748</SPAN>	175470122</SPAN>	B</SPAN>
473132752</SPAN>	698343</SPAN>	A</SPAN>
473132752</SPAN>	474051970</SPAN>	B</SPAN>
473132752</SPAN>	474052093</SPAN>	B</SPAN>
473132752</SPAN>	474213901</SPAN>	B</SPAN>
473132766</SPAN>	698959</SPAN>	A</SPAN>
473132766</SPAN>	459759728</SPAN>	B</SPAN>
473132766</SPAN>	459759730</SPAN>	B</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>

Basically, every match id should have equal number of As and Bs, that is, match id 473132746 should have 2 As as CP and 2 Bs as CP or one of each.
I want to write a formula that picks out the whether the number of As and Bs per match id are equal or not. I was trying to combine a countfs and match function but not getting anywhere

 

[Momentman]

I added 3 more columns for simplicity. Might this be what you want?

Excel 2010
	A	B	C	D	E	F
1	MATCH_ID	SUM ID	CP	Number of A's	Number of B's	Are they equal?
2	473132746	698131	A	1	2	FALSE
3	473132746	459759729	B	1	2	FALSE
4	473132746	459759732	B	1	2	FALSE
5	473132748	698153	A	1	2	FALSE
6	473132748	175466963	B	1	2	FALSE
7	473132748	175470122	B	1	2	FALSE
8	473132752	698343	A	1	3	FALSE
9	473132752	474051970	B	1	3	FALSE
10	473132752	474052093	B	1	3	FALSE
11	473132752	474213901	B	1	3	FALSE
12	473132766	698959	A	1	2	FALSE
13	473132766	459759728	B	1	2	FALSE
14	473132766	459759730	B	1	2	FALSE
Sheet1

Cell Formulas
Range	Formula
D2	=COUNTIFS($A$2:$A$14,A2,$C$2:$C$14,"A")
E2	=COUNTIFS($A$2:$A$14,A2,$C$2:$C$14,"B")
F2	=D2=E2

 

[Snakehips]

Shree1,

Welcome to MrExcel.

Perhaps,....

Excel 2007
	A	B	C	D
1	MATCH_ID	SUM ID	CP
2	473132746	698131	A	FALSE
3	473132746	459759729	B	FALSE
4	473132746	459759732	B	FALSE
5	473132748	698153	A	FALSE
6	473132748	175466963	B	FALSE
7	473132748	175470122	B	FALSE
8	473132752	698343	A	TRUE
9	473132752	474051970	B	TRUE
10	473132752	474052093	B	TRUE
11	473132752	474213901	A	TRUE
12	473132766	698959	A	FALSE
13	473132766	459759728	B	FALSE
14	473132766	459759730	B	FALSE
Sheet1

Cell Formulas
Range	Formula
D2	=COUNTIFS($A$2:$A$30,A2,$C$2:$C$30,"A")=COUNTIFS($A$2:$A$30,A2,$C$2:$C$30,"B")

Hope that helps.

 

[Shree1]

Thanks!