Count Duplicate Values of a Certain Cell in a Table but Only Count for One Instance in a Certain Range Within Table

psmi123

New Member
Joined
Jul 10, 2018
Messages
16
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! :)
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Try

Array formula in F2 copied across and down
=SUM(IF(FREQUENCY(IF(MMULT(--($C$2:$E$9=C2),{1;1;1})>0,MATCH($B$2:$B$9,$B$2:$B$9,0)),ROW($B$2:$B$9)-ROW($B$2)+1),1))
confirmed with Ctrl+Shift+Enter, not just Enter

M.
 
Last edited:
Upvote 0
This works! However, what if there are multiple sectors and I only want the codes counted within the sector as well, how would I do that? Also do you mind explaining the formula? So i can translate it to the bigger file?
 
Upvote 0
To handle multiple sectors we need to add a new criteria (column A)

[Table="class: grid"][tr][td="bgcolor: #DCE6F1"][/td][td="bgcolor: #DCE6F1"]
A
[/td][td="bgcolor: #DCE6F1"]
B
[/td][td="bgcolor: #DCE6F1"]
C
[/td][td="bgcolor: #DCE6F1"]
D
[/td][td="bgcolor: #DCE6F1"]
E
[/td][td="bgcolor: #DCE6F1"]
F
[/td][td="bgcolor: #DCE6F1"]
G
[/td][td="bgcolor: #DCE6F1"]
H
[/td][/tr]
[tr][td="bgcolor: #DCE6F1"]
1
[/td][td]
Sector​
[/td][td]
Zone​
[/td][td]
Code 1​
[/td][td]
Code 2​
[/td][td]
Code 3​
[/td][td]
Code 1 Occurrences​
[/td][td]
Code 2 Occurrences​
[/td][td]
Code 3 Occurrences​
[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
2
[/td][td]
Ice Cream​
[/td][td]
1​
[/td][td]
C2.2​
[/td][td]
C.4​
[/td][td]
C3.5​
[/td][td]
3​
[/td][td]
2​
[/td][td]
3​
[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
3
[/td][td]
Ice Cream​
[/td][td]
1​
[/td][td]
C2.2​
[/td][td]
C3.5​
[/td][td]
R4.7​
[/td][td]
3​
[/td][td]
3​
[/td][td]
2​
[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
4
[/td][td]
Ice Cream​
[/td][td]
2​
[/td][td]
C2.2​
[/td][td]
F3.4​
[/td][td]
U7.9​
[/td][td]
3​
[/td][td]
4​
[/td][td]
3​
[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
5
[/td][td]
Ice Cream​
[/td][td]
3​
[/td][td]
C3.5​
[/td][td]
F3.4​
[/td][td]
U7.9​
[/td][td]
3​
[/td][td]
4​
[/td][td]
3​
[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
6
[/td][td]
Ice Cream​
[/td][td]
4​
[/td][td]
F3.4​
[/td][td]
U7.9​
[/td][td]
R4.7​
[/td][td]
4​
[/td][td]
3​
[/td][td]
2​
[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
7
[/td][td]
Ice Cream​
[/td][td]
5​
[/td][td]
C2.2​
[/td][td]
C.4​
[/td][td]
C3.5​
[/td][td]
3​
[/td][td]
2​
[/td][td]
3​
[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
8
[/td][td]
Ice Cream​
[/td][td]
5​
[/td][td]
C2.2​
[/td][td]
C.4​
[/td][td]
F3.4​
[/td][td]
3​
[/td][td]
2​
[/td][td]
4​
[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
9
[/td][td]
Ice Cream​
[/td][td]
5​
[/td][td]
C3.5​
[/td][td]
C.4​
[/td][td]
F3.4​
[/td][td]
3​
[/td][td]
2​
[/td][td]
4​
[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
10
[/td][td]
xxxx​
[/td][td]
1​
[/td][td]
C2.2​
[/td][td]
C.4​
[/td][td]
C3.5​
[/td][td]
2​
[/td][td]
1​
[/td][td]
2​
[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
11
[/td][td]
xxxx​
[/td][td]
1​
[/td][td]
C2.2​
[/td][td]
C3.5​
[/td][td]
R4.7​
[/td][td]
2​
[/td][td]
2​
[/td][td]
1​
[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
12
[/td][td]
xxxx​
[/td][td]
2​
[/td][td]
C2.2​
[/td][td]
F3.4​
[/td][td]
U7.9​
[/td][td]
2​
[/td][td]
2​
[/td][td]
2​
[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]
13
[/td][td]
xxxx​
[/td][td]
3​
[/td][td]
C3.5​
[/td][td]
F3.4​
[/td][td]
U7.9​
[/td][td]
2​
[/td][td]
2​
[/td][td]
2​
[/td][/tr]
[/table]


Array formula in F2 copied across and down
=SUM(IF(FREQUENCY(IF($A$2:$A$13=$A2,IF(MMULT(--($C$2:$E$13=C2),{1;1;1})>0,MATCH($B$2:$B$13,$B$2:$B$13,0))),ROW($B$2:$B$13)-ROW($B$2)+1),1))
Ctrl+Shift+Enter

To understand what the formula does, step by step, try Formulas > Evaluate formula

M.
 
Upvote 0
So its working in the sample problem but I cant translate it to my file.

=SUM(IF(FREQUENCY(IF($A$2:$A$13=$A2,IF(MMULT(--($C$2:$E$13=C2),{1;1;1})>0,MATCH($B$2:$B$13,$B$2:$B$13,0))),ROW($B$2:$B$13)-ROW($B$2)+1),1))

I tried to evaluate it but its not making sense, could u please explain to me the part of the formula thats in red?
 
Upvote 0
The formula is a bit complicated and difficult to explain. To understand it, you must know how to use the FREQUENCY function to count without duplicates (count unique).

In this case, it is necessary to consider two criteria, i.e.: same sector - which is verified by $A$2:$A$13=$A2; and on which rows the value in C2 is present - which is tested by MMULT(--($C$2:$E$13=C2),{1;1;1})>0

Could you show us a sample of data that represents your real scenario? So I could try to adapt the formula.

M.
 
Last edited:
Upvote 0
That makes sense! Below is a better sample of the data

2 More questions as well if you don't mind answering:

1.) What does {1;1;1})>0 mean? Could you please explain to me what ROW($B$2:$B$13)-ROW($B$2)+1),1)) is doing?

2.) For -ROW($B$2)+1),1)) what is the subtracting doing? Also why would $B$2 stay the same if its only referencing one cell the time? Would it make more sense to remove the $ before the 2? and what is the function of that plus one?

Thank you so much for your help, it is greatly appreciated!



[TABLE="width: 6754"]
<colgroup><col><col><col span="2"><col><col span="4"><col><col span="4"><col><col span="2"><col><col><col><col span="2"><col><col><col><col><col><col><col><col><col><col span="8"><col><col><col span="8"><col><col></colgroup><tbody>[TR]
[TD]Sector[/TD]
[TD]Zone[/TD]
[TD]Column C[/TD]
[TD]Column D[/TD]
[TD]Column E[/TD]
[TD]Column F[/TD]
[TD]Column G[/TD]
[TD]Column H[/TD]
[TD]Column I[/TD]
[TD]Code 1[/TD]
[TD]Code 2[/TD]
[TD]Code 3[/TD]
[TD]Code 4[/TD]
[TD]Code 5[/TD]
[TD]Code 6[/TD]
[TD]Code 7[/TD]
[TD]Code 8[/TD]
[TD]Code 9[/TD]
[TD]Code 10[/TD]
[TD]Code 11[/TD]
[TD]Code 12[/TD]
[TD]Code 13[/TD]
[TD]Code 14[/TD]
[TD]Code 15[/TD]
[TD]Code 16[/TD]
[TD]Code 17[/TD]
[TD]Code 18[/TD]
[TD]Code 19[/TD]
[TD]Code 20[/TD]
[TD]Code 21[/TD]
[TD]Code 1 Occurrence[/TD]
[TD]Code 2 Occurrence[/TD]
[TD]Code 3 Occurrence[/TD]
[TD]Code 4 Occurrence[/TD]
[TD]Code 5 Occurrence[/TD]
[TD]Code 6 Occurrence[/TD]
[TD]Code 7 Occurrence[/TD]
[TD]Code 8 Occurrence[/TD]
[TD]Code 9 Occurrence[/TD]
[TD]Code 10 Occurrence[/TD]
[TD]Code 11 Occurrence[/TD]
[TD]Code 12 Occurrence[/TD]
[TD]Code 13 Occurrence[/TD]
[TD]Code 14 Occurrence[/TD]
[TD]Code 15 Occurrence[/TD]
[TD]Code 16 Occurrence[/TD]
[TD]Code 17 Occurrence[/TD]
[TD]Code 18 Occurrence[/TD]
[TD]Code 19 Occurrence[/TD]
[TD]Code 20 Occurrence[/TD]
[TD]Code 21 Occurrence[/TD]
[/TR]
[TR]
[TD]Unnamed[/TD]
[TD]16[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Unnamed[/TD]
[TD]36[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Unnamed[/TD]
[TD]38[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Unnamed[/TD]
[TD]48[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Unnamed[/TD]
[TD]50[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]2[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]U1.13.2.0.0.0[/TD]
[TD]U1.0.0.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]5[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]U1.18.1.0.0.0[/TD]
[TD]U1.18.3.0.0.0[/TD]
[TD]U1.18.0.0.0.0[/TD]
[TD]U1.18.4.0.0.0[/TD]
[TD]U1.18.0.0.0.0[/TD]
[TD]U1.18.0.0.0.0[/TD]
[TD]G3.3.0.0.0.0[/TD]
[TD]U1.18.0.0.0.0[/TD]
[TD]U1.15.0.0.0.0[/TD]
[TD]U1.1.0.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]6[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]U1.18.4.0.0.0[/TD]
[TD]U1.15.1.0.0.0[/TD]
[TD]U1.2.5.0.0.0[/TD]
[TD]U1.15.2.0.0.0[/TD]
[TD]U1.15.3.0.0.0[/TD]
[TD]U1.9.0.0.0.0[/TD]
[TD]U1.2.0.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]8[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]U1.1.7.0.0.0[/TD]
[TD]U1.16.0.0.0.0[/TD]
[TD]U1.1.0.0.0.0[/TD]
[TD]U1.1.0.0.0.0[/TD]
[TD]U1.13.1.0.0.0[/TD]
[TD]U1.16.3.0.0.0[/TD]
[TD]U1.16.1.0.0.0[/TD]
[TD]U1.2.5.0.0.0[/TD]
[TD]TBD[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]9[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]U1.10.0.0.0.0[/TD]
[TD]U1.10.0.0.0.0[/TD]
[TD]U1.10.3.0.0.0[/TD]
[TD]U1.10.4.0.0.0[/TD]
[TD]U1.2.0.0.0.0[/TD]
[TD]U1.20.0.0.0.0[/TD]
[TD]U1.13.2.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]10[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]U1.4.0.0.0.0[/TD]
[TD]U1.2.0.0.0.0[/TD]
[TD]U1.18.4.0.0.0[/TD]
[TD]U1.9.0.0.0.0[/TD]
[TD]U1.20.0.0.0.0[/TD]
[TD]U1.1.0.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]12[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]U1.18.0.0.0.0[/TD]
[TD]TBD[/TD]
[TD]TBD[/TD]
[TD]TBD[/TD]
[TD]TBD[/TD]
[TD]TBD[/TD]
[TD]TBD[/TD]
[TD]TBD[/TD]
[TD]TBD[/TD]
[TD]TBD[/TD]
[TD]TBD[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]13[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]U1.21.7.0.0.0[/TD]
[TD]U1.21.7.0.0.0[/TD]
[TD]U1.21.7.0.0.0[/TD]
[TD]U1.21.7.0.0.0[/TD]
[TD]U1.21.7.0.0.0[/TD]
[TD]U1.21.7.0.0.0[/TD]
[TD]G4.1.0.0.0.0[/TD]
[TD]U1.18.0.0.0.0[/TD]
[TD]U1.21.3.0.0.0[/TD]
[TD]U1.4.0.0.0.0[/TD]
[TD]U1.2.0.0.0.0[/TD]
[TD]U1.5.0.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]15[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]U1.18.0.0.0.0[/TD]
[TD]U1.15.2.0.0.0[/TD]
[TD]U1.0.0.0.0.0[/TD]
[TD]U1.8.0.0.0.0[/TD]
[TD]G5.4.1.0.0.0[/TD]
[TD]U1.18.4.0.0.0[/TD]
[TD]U1.2.1.0.0.0[/TD]
[TD]G4.3.0.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]17[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]G1.3.0.0.0.0[/TD]
[TD]G1.3.0.0.0.0[/TD]
[TD]G1.8.4.0.0.0[/TD]
[TD]G1.10.0.0.0.0[/TD]
[TD]G1.9.0.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]17[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]G1.2.0.0.0.0[/TD]
[TD]G1.3.0.0.0.0[/TD]
[TD]U1.12.0.0.0.0[/TD]
[TD]G1.3.3.0.0.0[/TD]
[TD]G1.10.0.0.0.0[/TD]
[TD]G1.9.0.0.0.0[/TD]
[TD]G1.15.2.0.0.0[/TD]
[TD]G4.2.0.0.0.0[/TD]
[TD]U1.2.1.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]17[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]G1.2.0.0.0.0[/TD]
[TD]G1.3.0.0.0.0[/TD]
[TD]U1.12.0.0.0.0[/TD]
[TD]G1.4.0.0.0.0[/TD]
[TD]G1.1.0.0.0.0[/TD]
[TD]G1.3.3.0.0.0[/TD]
[TD]G1.8.1.0.0.0[/TD]
[TD]G1.8.2.0.0.0[/TD]
[TD]G1.8.3.0.0.0[/TD]
[TD]G1.8.4.0.0.0[/TD]
[TD]G1.10.0.0.0.0[/TD]
[TD]G1.9.0.0.0.0[/TD]
[TD]G1.6.0.0.0.0[/TD]
[TD]G1.15.2.0.0.0[/TD]
[TD]G1.11.0.0.0.0[/TD]
[TD]G1.13.0.0.0.0[/TD]
[TD]G4.2.0.0.0.0[/TD]
[TD]U1.2.1.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]18[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]TBD[/TD]
[TD]TBD[/TD]
[TD]TBD[/TD]
[TD]TBD[/TD]
[TD]TBD[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]21[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]TBD[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]27[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]G1.3.0.0.0.0[/TD]
[TD]G1.15.1.0.0.0[/TD]
[TD]G5.1.5.0.0.0[/TD]
[TD]G1.13.0.0.0.0[/TD]
[TD]G4.2.5.0.0.0[/TD]
[TD]U1.4.0.0.0.0[/TD]
[TD]U1.2.0.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]27[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]G1.3.0.0.0.0[/TD]
[TD]G1.15.1.0.0.0[/TD]
[TD]G5.1.5.0.0.0[/TD]
[TD]G4.2.5.0.0.0[/TD]
[TD]U1.4.0.0.0.0[/TD]
[TD]U1.2.0.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]27[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]G1.3.0.0.0.0[/TD]
[TD]G1.15.1.0.0.0[/TD]
[TD]G5.1.5.0.0.0[/TD]
[TD]G1.13.0.0.0.0[/TD]
[TD]G4.2.5.0.0.0[/TD]
[TD]U1.4.0.0.0.0[/TD]
[TD]U1.2.0.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]27[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]G1.3.0.0.0.0[/TD]
[TD]G1.15.1.0.0.0[/TD]
[TD]G5.1.5.0.0.0[/TD]
[TD]G1.13.0.0.0.0[/TD]
[TD]G4.2.5.0.0.0[/TD]
[TD]U1.4.0.0.0.0[/TD]
[TD]U1.2.0.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]28[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]G1.3.3.0.0.0[/TD]
[TD]G4.2.0.0.0.0[/TD]
[TD]G5.1.2.1[/TD]
[TD]G5.1.2.2.0.0[/TD]
[TD]U1.11.5.0.0.0[/TD]
[TD]G7.3.0.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]29[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]TBD[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]30[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]U1.20.1.0.0.0[/TD]
[TD]U1.20.2.0.0.0[/TD]
[TD]U1.20.3.0.0.0[/TD]
[TD]U1.20.4.0.0.0[/TD]
[TD]U1.20.0.0.0.0[/TD]
[TD]N/A[/TD]
[TD]U1.10.3.0.0.0[/TD]
[TD]U1.2.0.0.0.0[/TD]
[TD]U1.20.4.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]31[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]U1.0.0.0.0.0[/TD]
[TD]U1.2.0.0.0.0[/TD]
[TD]U1.9.3.0.0.0[/TD]
[TD]U1.9.6.0.0.0[/TD]
[TD]U1.9.5.0.0.0[/TD]
[TD]U1.9.6.0.0.0[/TD]
[TD]U1.9.6.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]33[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]G5.4.1.0.0.0[/TD]
[TD]G5.4.5.0.0.0[/TD]
[TD]G5.4.4.0.0.0[/TD]
[TD]G5.5.0.0.0.0[/TD]
[TD]G5.4.3.0.0.0[/TD]
[TD]U1.2.0.0.0.0[/TD]
[TD]U1.11.5.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]35[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]TBD[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]37[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]G5.1.1.0.0.0[/TD]
[TD]G5.1.3.0.0.0[/TD]
[TD]G5.1.2.0.0.0[/TD]
[TD]G5.1.4.0.0.0[/TD]
[TD]G5.1.3.2.0.0[/TD]
[TD]G5.1.3.3.0.0[/TD]
[TD]G5.1.3.1.0.0[/TD]
[TD]U1.17.2.0.0.0[/TD]
[TD]U1.2.0.0.0.0[/TD]
[TD]U1.11.0.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]37[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]G5.1.1.0.0.0[/TD]
[TD]G5.1.2.0.0.0[/TD]
[TD]G5.1.4.0.0.0[/TD]
[TD]U1.17.2.0.0.0[/TD]
[TD]U1.11.0.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]37[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]G5.1.1.0.0.0[/TD]
[TD]G5.1.3.0.0.0[/TD]
[TD]G5.1.2.0.0.0[/TD]
[TD]G5.1.4.0.0.0[/TD]
[TD]G5.1.3.2.0.0[/TD]
[TD]G5.1.3.3.0.0[/TD]
[TD]G5.1.3.1.0.0[/TD]
[TD]U1.17.2.0.0.0[/TD]
[TD]U1.2.0.0.0.0[/TD]
[TD]U1.11.0.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]39[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]TBD[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]40[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]N/A[/TD]
[TD]G5.4.4.2.0.0[/TD]
[TD]G5.4.4.1.0.0[/TD]
[TD]U1.11.3.0.0.0[/TD]
[TD]G5.3.1.0.0.0[/TD]
[TD]G5.3.2.0.0.0[/TD]
[TD]G5.5.0.0.0.0[/TD]
[TD]U1.2.0.0.0.0[/TD]
[TD]U1.11.0.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]41[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]TBD[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]42[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]TBD[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]43[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]G7.2.1.0.0.0[/TD]
[TD]G7.2.2.0.0.0[/TD]
[TD]G7.2.3.0.0.0[/TD]
[TD]G7.2.4.0.0.0[/TD]
[TD]G5.4.7.1.0.0[/TD]
[TD]G5.1.4.0.0.0[/TD]
[TD]G5.4.7.2.0.0[/TD]
[TD]G7.3.4.0.0.0[/TD]
[TD]U1.16.3.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]44[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]TBD[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]44[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]TBD[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]45[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]U1.18.0.0.0.0[/TD]
[TD]U1.2.0.0.0.0[/TD]
[TD]U1.12.B[/TD]
[TD]U1.16.3.0.0.0[/TD]
[TD]U1.9.0.0.0.0[/TD]
[TD]U1.13.2.0.0.0[/TD]
[TD]U1.14.0.0.0.0[/TD]
[TD]U1.16.1.0.0.0[/TD]
[TD]U1.1.0.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]46[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]U1.19.0.0.0.0[/TD]
[TD]G5.4.2.0.0.0[/TD]
[TD]U1.19.0.0.0.0[/TD]
[TD]G5.4.0.0.0.0[/TD]
[TD]U1.9.0.0.0.0[/TD]
[TD]U1.9.6.0.0.0[/TD]
[TD]U1.2.1.4.0.0[/TD]
[TD]U1.12.0.0.0.0[/TD]
[TD]U1.0.0.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ice Cream[/TD]
[TD]47[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]U1.19.0.0.0.0[/TD]
[TD]U1.19.0.0.0.0[/TD]
[TD]U1.19.0.0.0.0[/TD]
[TD]U1.19.0.0.0.0[/TD]
[TD]U1.10.0.0.0.0[/TD]
[TD]U1.2.1.4.0.0.0[/TD]
[TD]U1.0.0.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Frozen Yogurt[/TD]
[TD]7[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]U1.17.1.4.0.0[/TD]
[TD]U1.17.1.3.0.0[/TD]
[TD]U1.2.0.0.0.0[/TD]
[TD]U1.17.2.1.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Frozen Yogurt[/TD]
[TD]15[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]U1.18.0.0.0.0[/TD]
[TD]U1.15.2.0.0.0[/TD]
[TD]U1.0.0.0.0.0[/TD]
[TD]U1.8.0.0.0.0[/TD]
[TD]G5.4.1.0.0.0[/TD]
[TD]U1.18.4.0.0.0[/TD]
[TD]U1.2.1.0.0.0[/TD]
[TD]G4.3.0.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Frozen Yogurt[/TD]
[TD]6[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]U1.18.4.0.0.0[/TD]
[TD]U1.15.1.0.0.0[/TD]
[TD]U1.2.5.0.0.0[/TD]
[TD]U1.15.2.0.0.0[/TD]
[TD]U1.15.3.0.0.0[/TD]
[TD]U1.16.1.0.0.0[/TD]
[TD]U1.16.0.0.0.0[/TD]
[TD]U1.9.0.0.0.0[/TD]
[TD]U1.2.0.0.0.0[/TD]
[TD]TBD[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Frozen Yogurt[/TD]
[TD]46[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]U1.19.0.0.0.0[/TD]
[TD]G5.4.2.0.0.0[/TD]
[TD]U1.19.0.0.0.0[/TD]
[TD]G5.4.0.0.0.0[/TD]
[TD]U1.9.0.0.0.0[/TD]
[TD]U1.9.6.0.0.0[/TD]
[TD]U1.2.1.4.0.0[/TD]
[TD]U1.12.0.0.0.0[/TD]
[TD]U1.0.0.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Frozen Yogurt[/TD]
[TD]29[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]TBD[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Frozen Yogurt[/TD]
[TD]17[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]G1.2.0.0.0.0[/TD]
[TD]G1.3.0.0.0.0[/TD]
[TD]U1.12.0.0.0.0[/TD]
[TD]G1.8.3.0.0.0[/TD]
[TD]G1.10.0.0.0.0[/TD]
[TD]G1.9.0.0.0.0[/TD]
[TD]G1.15.2.0.0.0[/TD]
[TD]G1.13.0.0.0.0[/TD]
[TD]G4.2.0.0.0.0[/TD]
[TD]U1.2.1.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Frozen Yogurt[/TD]
[TD]17[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]Non Relevant Info[/TD]
[TD]G1.2.0.0.0.0[/TD]
[TD]G1.3.0.0.0.0[/TD]
[TD]U1.12.0.0.0.0[/TD]
[TD]G1.8.3.0.0.0[/TD]
[TD]G1.10.0.0.0.0[/TD]
[TD]G1.9.0.0.0.0[/TD]
[TD]G1.15.2.0.0.0[/TD]
[TD]G4.2.0.0.0.0[/TD]
[TD]U1.2.1.0.0.0[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
{1;1;1} is used as the second argument of MMULT to generate an array with one column. The vertical array, resultant of MMULT, will contain 1 for those rows that contain the code in question and 0 for the rows that do not contain the code in question. For this reason the formula uses MMULT(....)>0 to identify the rows that contain the code in question.

I used a vertical array with 3 elements because there are 3 columns with codes (columns C to E). With four columns with codes you should use, as the second argument of MMULT, a vertical array with 4 elements {1;1;1;1}. With 5 columns an array with 5 elements, and so on.

ROW($B$2:$B$13)-ROW($B$2)+1 generates a vertical array like
{1;2;3;4;5;6;7;8;9;10;11;12;13}

I'm noticing that you're not familiar with this type of formula. So to have a chance to understand the formula and to begin with, I recommend you watch this video (long, but excellent explanation of how to use the FREQUENCY function to count unique)
https://www.youtube.com/watch?v=uUrI8hoj8BA

M.
 
Last edited:
Upvote 0
All I had to do was change the array to fit my range! Thank you so much for your help, and I will watch that video!
 
Upvote 0
So I'm currently watching the video and I'm only confused on SUM(IF(FREQUENCY(IF($A$2:$A$13=$A2,IF(MMULT(--($C$2:$E$13=C2),{1;1;1})>0,MATCH($B$2:$B$13,$B$2:$B$13,0))),ROW($B$2:$B$13)-ROW($B$2)+1),1))

I still don't understand why there would be a $ in front of the 2? Wouldn't they all just be pulling from the same zone? He didn't really go too in depth with that part so I'm still trying to understand it.

Thank you!

-P
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,325
Members
452,635
Latest member
laura12345

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top