Hey,
I need a way to calculate overlap between Groups but not within the same group. I need to make a template where a user can input the group name and the Numbers associate and have a easy checker to see if there is any overlap between the groups. Ideally there is a Button which runs a Macro and the problematic SKU_NO's are identified.
Example:
In this example (Very simplified) I have 3 groups which associated SKU_NO's, As you can observe there is over lap between groups. I would like to Identify the SKU_NO which are causing the overlap but I would not want SKU_NO = A to be identified as causing an overlap as duplication within a SKU_GROUP is not a problem.
SKU_GROUP SKU_NO
OFFER A
OFFER A
OFFER B
COMP C
COMP B
BRAND C
BRAND X
BRAND Y
Any help is much appreciated.
I need a way to calculate overlap between Groups but not within the same group. I need to make a template where a user can input the group name and the Numbers associate and have a easy checker to see if there is any overlap between the groups. Ideally there is a Button which runs a Macro and the problematic SKU_NO's are identified.
Example:
In this example (Very simplified) I have 3 groups which associated SKU_NO's, As you can observe there is over lap between groups. I would like to Identify the SKU_NO which are causing the overlap but I would not want SKU_NO = A to be identified as causing an overlap as duplication within a SKU_GROUP is not a problem.
SKU_GROUP SKU_NO
OFFER A
OFFER A
OFFER B
COMP C
COMP B
BRAND C
BRAND X
BRAND Y
Any help is much appreciated.
