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.
<tbody>
</tbody>
Thank you for your review and help.
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.