I envision a summary as such:
[TABLE="width: 270"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD]Seller[/TD]
[TD]GAP[/TD]
[TD]MBP[/TD]
[TD]BOTH[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Veronica[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Diana[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Kevin[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
Raw data is as follows:
[TABLE="width: 266"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Seller[/TD]
[TD]Account number[/TD]
[TD]Product[/TD]
[/TR]
[TR]
[TD]Kevin[/TD]
[TD]123[/TD]
[TD]GAP[/TD]
[/TR]
[TR]
[TD]Veronica[/TD]
[TD]456[/TD]
[TD]GAP[/TD]
[/TR]
[TR]
[TD]Veronica[/TD]
[TD]456[/TD]
[TD]MBP[/TD]
[/TR]
[TR]
[TD]Kevin[/TD]
[TD]789[/TD]
[TD]MBP[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]987[/TD]
[TD]GAP[/TD]
[/TR]
[TR]
[TD]Veronica[/TD]
[TD]654[/TD]
[TD]MBP[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]321[/TD]
[TD]GAP[/TD]
[/TR]
[TR]
[TD]Diana[/TD]
[TD]657[/TD]
[TD]MBP
[/TD]
[/TR]
</tbody>[/TABLE]
I want it to count products sold by each seller (and account) with a wrinkle.
For example, Veronica would have a count of 1 in the MBP column and 1 in the BOTH column based on the above data because she sold BOTH products to one account (456) and only one product to the other account (654).
Hope this is clear. This board is immensely helpful. Thanks in advance!!
[TABLE="width: 270"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD]Seller[/TD]
[TD]GAP[/TD]
[TD]MBP[/TD]
[TD]BOTH[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Veronica[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Diana[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Kevin[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
Raw data is as follows:
[TABLE="width: 266"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Seller[/TD]
[TD]Account number[/TD]
[TD]Product[/TD]
[/TR]
[TR]
[TD]Kevin[/TD]
[TD]123[/TD]
[TD]GAP[/TD]
[/TR]
[TR]
[TD]Veronica[/TD]
[TD]456[/TD]
[TD]GAP[/TD]
[/TR]
[TR]
[TD]Veronica[/TD]
[TD]456[/TD]
[TD]MBP[/TD]
[/TR]
[TR]
[TD]Kevin[/TD]
[TD]789[/TD]
[TD]MBP[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]987[/TD]
[TD]GAP[/TD]
[/TR]
[TR]
[TD]Veronica[/TD]
[TD]654[/TD]
[TD]MBP[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]321[/TD]
[TD]GAP[/TD]
[/TR]
[TR]
[TD]Diana[/TD]
[TD]657[/TD]
[TD]MBP
[/TD]
[/TR]
</tbody>[/TABLE]
I want it to count products sold by each seller (and account) with a wrinkle.
For example, Veronica would have a count of 1 in the MBP column and 1 in the BOTH column based on the above data because she sold BOTH products to one account (456) and only one product to the other account (654).
Hope this is clear. This board is immensely helpful. Thanks in advance!!