Lets use C2.2 in Cell C2 for an example . I know how to count the number of occurrences of a certain cell within a table. However I want to be able to exclude the count of duplicate within a zone. In the table C2.2 appears 4 times. However I want to exclude duplicates within the zones and only have it count once per zone. Another example: C.4 occurs 4 times in the table but 3 of those occurrences are within zone 5 of ice cream therefore I only want it to be counted once within Zone 5, therefore i want the total number occurrences of C.4 to be 2. I am going to fill out F2:H9 on what value is supposed to shown. But I need to know how to do this without counting manually, any advice would be greatly appreciated. The Data set I am using is very large and it would take too long to count manually and I want the file to update itself.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Sector[/TD]
[TD="align: center"]Zone[/TD]
[TD="align: center"]Code 1[/TD]
[TD="align: center"]Code 2[/TD]
[TD="align: center"]Code 3[/TD]
[TD="align: center"]Code 1 Occurrences[/TD]
[TD="align: center"]Code 2 Occurrences[/TD]
[TD="align: center"]Code 3 Occurrences[/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]1[/TD]
[TD]C2.2[/TD]
[TD]C.4[/TD]
[TD]C3.5[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]1[/TD]
[TD]C2.2[/TD]
[TD]C3.5[/TD]
[TD]R4.7[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]2[/TD]
[TD]C2.2[/TD]
[TD]F3.4[/TD]
[TD]U7.9[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]3[/TD]
[TD]C3.5[/TD]
[TD]F3.4[/TD]
[TD]U7.9[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]4[/TD]
[TD]F3.4[/TD]
[TD]U7.9[/TD]
[TD]R4.7[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]5[/TD]
[TD]C2.2[/TD]
[TD]C.4[/TD]
[TD]C3.5[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]5[/TD]
[TD]C2.2[/TD]
[TD]C.4[/TD]
[TD]F3.4[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]4[/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]5[/TD]
[TD]C3.5[/TD]
[TD]C.4[/TD]
[TD]F3.4[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]4[/TD]
[/TR]
</tbody>[/TABLE]
Thank you in advance for the help!
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Sector[/TD]
[TD="align: center"]Zone[/TD]
[TD="align: center"]Code 1[/TD]
[TD="align: center"]Code 2[/TD]
[TD="align: center"]Code 3[/TD]
[TD="align: center"]Code 1 Occurrences[/TD]
[TD="align: center"]Code 2 Occurrences[/TD]
[TD="align: center"]Code 3 Occurrences[/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]1[/TD]
[TD]C2.2[/TD]
[TD]C.4[/TD]
[TD]C3.5[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]1[/TD]
[TD]C2.2[/TD]
[TD]C3.5[/TD]
[TD]R4.7[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]2[/TD]
[TD]C2.2[/TD]
[TD]F3.4[/TD]
[TD]U7.9[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]3[/TD]
[TD]C3.5[/TD]
[TD]F3.4[/TD]
[TD]U7.9[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]4[/TD]
[TD]F3.4[/TD]
[TD]U7.9[/TD]
[TD]R4.7[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]5[/TD]
[TD]C2.2[/TD]
[TD]C.4[/TD]
[TD]C3.5[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]5[/TD]
[TD]C2.2[/TD]
[TD]C.4[/TD]
[TD]F3.4[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]4[/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]5[/TD]
[TD]C3.5[/TD]
[TD]C.4[/TD]
[TD]F3.4[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]4[/TD]
[/TR]
</tbody>[/TABLE]
Thank you in advance for the help!