Multiple criteria

[Shree1]

I have a data set that looks like the below

[TABLE="width: 323"]
<TBODY>[TR]
[TD]MATCH_ID</SPAN>[/TD]
[TD]SUM ID</SPAN>[/TD]
[TD]CP</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]473132746</SPAN>[/TD]
[TD="align: right"]698131</SPAN>[/TD]
[TD]A</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]473132746</SPAN>[/TD]
[TD="align: right"]459759729</SPAN>[/TD]
[TD]B</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]473132746</SPAN>[/TD]
[TD="align: right"]459759732</SPAN>[/TD]
[TD]B</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]473132748</SPAN>[/TD]
[TD="align: right"]698153</SPAN>[/TD]
[TD]A</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]473132748</SPAN>[/TD]
[TD="align: right"]175466963</SPAN>[/TD]
[TD]B</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]473132748</SPAN>[/TD]
[TD="align: right"]175470122</SPAN>[/TD]
[TD]B</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]473132752</SPAN>[/TD]
[TD="align: right"]698343</SPAN>[/TD]
[TD]A</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]473132752</SPAN>[/TD]
[TD="align: right"]474051970</SPAN>[/TD]
[TD]B</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]473132752</SPAN>[/TD]
[TD="align: right"]474052093</SPAN>[/TD]
[TD]B</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]473132752</SPAN>[/TD]
[TD="align: right"]474213901</SPAN>[/TD]
[TD]B</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]473132766</SPAN>[/TD]
[TD="align: right"]698959</SPAN>[/TD]
[TD]A</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]473132766</SPAN>[/TD]
[TD="align: right"]459759728</SPAN>[/TD]
[TD]B</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]473132766</SPAN>[/TD]
[TD="align: right"]459759730</SPAN>[/TD]
[TD]B</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>[/TABLE]


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!