Spreadsheet: 783749d1655120560-set-duplicate-value-to-zero-based-on-duplicate-value-in-another-cell-product-vs-cost
Sheet: DATA

Product | Cost of Item
20631 | 24163.96
20631 | 24163.96
20831 | 8684.73
22380 | 2114.68
22380 | 2114.68
23291 | 0
23657 | 0
23966 | 166209.98
23966 | 166209.98
24410 | 6238.15
24410 | 6238.15
24413 | 466627.51
24413 | 466627.51
26256 | 0
26256 | 0
28776 | 0
45456 | 0
46779 | 0
48841 | 1973.28
49128 | 32228.84
49130 | 0
49137 | 14140.19
49139 | 3350.69
49140 | 598.76
49176 | 1154.26
49192 | 7270.09
49218 | 0
49221 | 1881.7
49248 | 23666.64
49257 | 8667.68
49337 | 20180.23
49442 | 0
49461 | 0
49501 | 3460.38
49587 | 0
49615 | 0
49636 | 12347.35
49643 | 0
49656 | 5220.1
49662 | 0
49681 | 0
49692 | 141552.88
49752 | 11040.22
50069 | 16408.6
50070 | 3427.23
50096 | 168109.78
50136 | -1614.15
50138 | 0
50139 | 18071.42
50147 | -250
50262 | 17219.36
50263 | 14640.31
50284 | 1686.7
50297 | 0
50298 | 82978.98
50301 | 0
50323 | 42270.58
50366 | 0
50367 | 0
50376 | 43646.72
50429 | 0
50477 | 0
50535 | 0
50568 | 68447.4
50686 | 776.18
50709 | 0
50747 | 0
50767 | 0
50794 | 21705.09
50810 | 83181.95
51195 | 34504.72
51288 | 22047.97
51324 | 1663.15
51331 | 0
51389 | 42516.2
51390 | 41703.06
51402 | 1220.61
51403 | 25262.49
51413 | 6746.6
51424 | 1929.06
51445 | 0
51494 | 0
51495 | 19237.14
51502 | 2296.32
51512 | 0
51518 | 10363.22
51522 | 0
51969 | 139247.05
51988 | 28077.41
52015 | 58969.6
52369 | 0
52586 | 8632.85
52619 | 898.94
53117 | 0
53117 | 0
53994 | 5970.64
55012 | 24941.22
55338 | 0
56002 | 0
56082 | 9480.96
56082 | 9480.96
58285 | 0
58285 | 0
58490 | 4026.3
58490 | 4026.3
58765 | 23540
58765 | 23540
59616 | 50341.77
59831 | 18314.2
59837 | 26645.56
59837 | 26645.56
59838 | 0
59844 | 8241.56
60657 | 62560.97
60657 | 62560.97
61129 | 0
61632 | 18446.93
62151 | 1280.12
62151 | 1280.12
62184 | 0
62592 | 0
62634 | 0
63073 | 1239.3
63498 | 0
63498 | 0
63698 | 54332.78
63702 | 0
63705 | 752.65
64215 | 3209.76
64333 | 0
66411 | 0
66475 | 0
66720 | 565.48
66721 | 2091.28
68464 | 28917.79
68464 | 28917.79
68991 | 0
68992 | 0
69223 | 0
72380 | 310420.62
72380 | 310420.62
72488 | 7980.02
72707 | 25171.7
72707 | 25171.7
73328 | 0
73911 | 43984.37
74452 | 22107.4
74452 | 22107.4
74621 | 0
74632 | 15655.21
74951 | 46255.88
74951 | 46255.88
75294 | 439.28
75302 | 0
75673 | 4393.74
75887 | 18542.77
75887 | 18542.77
76378 | 0
78891 | 42238.16
78891 | 42238.16
81992 | -369.32
81992 | -369.32
82205 | 0
83094 | 0
83094 | 0
83365 | 0
83366 | 6575.79
83366 | 6575.79
83750 | 0
84515 | 0
84515 | 0
85140 | 134360
85140 | 134360
85694 | 11385.2
86523 | 0
88071 | 6296.9
88628 | 0
88866 | 20974.76
89299 | 5553.3
89299 | 5553.3
89688 | 15754.61
90562 | 0
90562 | 0
91775 | 0
92343 | 27574.3
92596 | 2998.62
92596 | 2998.62
93273 | 37379.88
95470 | 32741.73
95493 | 12947.32
99002 | 4964.67
99002 | 4964.67
99359 | 47501.42
99359 | 47501.42
99497 | 75712.85
99497 | 75712.85
99503 | 0
101136 | 3696.45
101136 | 3696.45
101138 | 16433.12
101772 | 9920.07
101811 | 2625.36
101965 | 11092.46
101965 | 11092.46
102875 | 0
102886 | 11419.04
102886 | 11419.04
103701 | 0
104631 | 51642.67
104631 | 51642.67
104632 | 16775.37
104632 | 16775.37
104869 | 0
105414 | 5236.49
105608 | 0
105768 | 19891.56
105954 | 5551.12
106429 | 16846.95
107741 | 189015.65
107741 | 189015.65
108172 | 40590.83
108172 | 40590.83
108374 | 15896.86
108374 | 15896.86
109575 | 0
110638 | 0
111503 | 0
112018 | 83920.27
112018 | 83920.27
112625 | 93023.4
112625 | 93023.4
112922 | 0
113415 | 17494.1
113415 | 17494.1
114325 | 0
114368 | 0
118126 | 72719.73
118126 | 72719.73