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

westc4

Board Regular
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.

Excel Facts

Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Snakehips

Well-known Member
westc4,

Try like ....

Excel Workbook
ABCDEFGHIJ
1CustomerCOUNTSOrg.DChlCGrpCHECKAAGCHECKPayTCHECK
211057003S001101Match1CheckN033Match
311057003S002101Match2CheckN033Match
411057003S030101Match1CheckN033Match
511057013S001107Check1MatchN012Match
611057013S002101Check1MatchN012Match
711057013S030101Check1MatchN012Match
811057053S001107Match1CheckN033Match
911057053S002107Match2CheckN033Match
1011057053S030107Match1CheckN033Match
1111057083S001107Check1MatchN012Match
1211057083S002101Check1MatchN012Match
1311057083S030101Check1MatchN012Match
14**********
Sheet4

Hope that helps.

westc4

Board Regular
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>

 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.

Replies
4
Views
566
Replies
2
Views
314
Replies
12
Views
449
Replies
7
Views
466
Replies
4
Views
368

1,191,347
Messages
5,986,136
Members
440,004
Latest member
Dynawoman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back