VBA or Formula to find miss-matched Data when Cell A matches

[westc4]

I need a formula or VBA function that can be used to find the miss-matched data.

If the Customer number (cell A) is the same, then Check that the CGrp match, Check that AAG match, Check Grp1 match, Check Grp3 match only when the Customer number is the same. ("Match" or "Check")

Start over with next set of Customer numbers. There are times that the count is 2, 3, 4 and 5. A formula for each Check is Ok.

Customer	COUNT	SOrg.	DChl	CGrp	CHECK	AAG	CHECK	PayT	CHECK	Grp1	CHECK	Grp3	CHECK
1105700	3	S001	10	1	Match	1	Check	N033	Match	46	Check		Check
1105700	3	S002	10	1	Match	2	Check	N033	Match	1	Check	CM1	Check
1105700	3	S030	10	1	Match	1	Check	N033	Match	46	Check		Check
1105701	3	S001	10	7		1		N012		47
1105701	3	S002	10	1		1		N012		47		CM1
1105701	3	S030	10	1		1		N012		18
1105705	3	S001	10	7		1		N033		47
1105705	3	S002	10	7		2		N033		47
1105705	3	S030	10	7		1		N033		1
1105708	3	S001	10	7		1		N012		47
1105708	3	S002	10	1		1		N012		46
1105708	3	S030	10	1		1		N012		47

<tbody>
</tbody>

Thank you for your review and help.

 

[Snakehips]

westc4,

Try like ....

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	Customer	COUNT	SOrg.	DChl	CGrp	CHECK	AAG	CHECK	PayT	CHECK
2	1105700	3	S001	10	1	Match	1	Check	N033	Match
3	1105700	3	S002	10	1	Match	2	Check	N033	Match
4	1105700	3	S030	10	1	Match	1	Check	N033	Match
5	1105701	3	S001	10	7	Check	1	Match	N012	Match
6	1105701	3	S002	10	1	Check	1	Match	N012	Match
7	1105701	3	S030	10	1	Check	1	Match	N012	Match
8	1105705	3	S001	10	7	Match	1	Check	N033	Match
9	1105705	3	S002	10	7	Match	2	Check	N033	Match
10	1105705	3	S030	10	7	Match	1	Check	N033	Match
11	1105708	3	S001	10	7	Check	1	Match	N012	Match
12	1105708	3	S002	10	1	Check	1	Match	N012	Match
13	1105708	3	S030	10	1	Check	1	Match	N012	Match
14	*	*	*	*	*	*	*	*	*	*
Sheet4

Hope that helps.

 

[westc4]

westc4,

Try like ....

Sheet4

*	A	B	C	D	E	F	G	H	I	J
1	Customer	COUNT	SOrg.	DChl	CGrp	CHECK	AAG	CHECK	PayT	CHECK
2	1105700	3	S001	10	1	Match	1	Check	N033	Match
3	1105700	3	S002	10	1	Match	2	Check	N033	Match
4	1105700	3	S030	10	1	Match	1	Check	N033	Match
5	1105701	3	S001	10	7	Check	1	Match	N012	Match
6	1105701	3	S002	10	1	Check	1	Match	N012	Match
7	1105701	3	S030	10	1	Check	1	Match	N012	Match
8	1105705	3	S001	10	7	Match	1	Check	N033	Match
9	1105705	3	S002	10	7	Match	2	Check	N033	Match
10	1105705	3	S030	10	7	Match	1	Check	N033	Match
11	1105708	3	S001	10	7	Check	1	Match	N012	Match
12	1105708	3	S002	10	1	Check	1	Match	N012	Match
13	1105708	3	S030	10	1	Check	1	Match	N012	Match
14	*	*	*	*	*	*	*	*	*	*

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula F2 =IF(A2="","",IF(COUNTIF($A$2:$A$200,$A2)=SUMPRODUCT(--($A$2:$A$200&$E$2:$E$200=A2&E2)),"Match","Check")) H2 =IF(A2="","",IF(COUNTIF($A$2:$A$200,$A2)=SUMPRODUCT(--($A$2:$A$200&$G$2:$G$200=A2&G2)),"Match","Check")) J2 =IF(A2="","",IF(COUNTIF($A$2:$A$200,$A2)=SUMPRODUCT(--($A$2:$A$200&$I$2:$I$200=A2&I2)),"Match","Check")) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Hope that helps.

That is just what I needed!! Thank you so much.