Spreadsheet: 219299d1362703052-find-upc-code-from-material-numbers-and-populate-3-bracket-prices-calculations2
Sheet: Sheet2

Customer: |  |  |  | Reclaim Fee |  | Chargeback
Case ID: |  |  |  | Price Difference | 316.17 | 316.17
X-Reference: |  |  |  | Total Valid | 1820.200000000001 |  |  | SOME WORK SOME DON’T |  |  |  | I NEED TO GROUP SAME PRICE ITEMS ACCORDING TO BRACKET 1 UNIT PRICE
Dispute Case Amount: |  |  |  | Total | 2136.37 |  |  |  |  |  |  | AND ADD THEIR BRACKET 1 UNIT TOTALS TO MAKE ONE TOTAL AMOUNT FOR THAT PRICE
 |  |  |  |  |  |  |  |  |  |  |  |  | MAKE THIS WORK
ENTER DATA HERE |  |  | DON’T TOUCH ANYTHING HERE |  |  |  |  | UPC can just be any one from the group
Enter [NAME] | Qty | Customer Amount | Customer Price | Bracket 1 Unit Price | Bracket 1 Unit Total | Price Difference |  |  | UPC | Bracket 1 Unit Price | Bracket 1 Unit Total
2 | 1 | 1.93 | 1.93 | 0 | 0 | 1.93 |  |  | 1775 | 0.9700000000000001 | 0.9700000000000001
1775 | 1 | 0.98 | 0.98 | 0.9700000000000001 | 0.9700000000000001 | 0.009999999999999898 |  |  | 1775 | 0.9700000000000001 | 5.82
1775 | 6 | 5.88 | 0.98 | 0.9700000000000001 | 5.82 | 0.05999999999999961 |  |  | 1776 | 0.9700000000000001 | 48.50000000000001
1776 | 50 | 49 | 0.98 | 0.9700000000000001 | 48.50000000000001 | 0.4999999999999929 |  |  | 1777 | 0.9700000000000001 | 10.67
1777 | 11 | 10.78 | 0.98 | 0.9700000000000001 | 10.67 | 0.1099999999999977 |  |  | 1777 | 0.9700000000000001 | 2.91
1777 | 3 | 2.94 | 0.98 | 0.9700000000000001 | 2.91 | 0.0299999999999998 |  |  | 1779 | 0.9700000000000001 | 17.46
1779 | 18 | 17.64 | 0.98 | 0.9700000000000001 | 17.46 | 0.1799999999999997 |  |  | 1779 | 0.9700000000000001 | 2.91
1779 | 3 | 2.94 | 0.98 | 0.9700000000000001 | 2.91 | 0.0299999999999998 |  |  | 1781 | 0.9700000000000001 | 42.68000000000001
1781 | 44 | 43.12 | 0.98 | 0.9700000000000001 | 42.68000000000001 | 0.4399999999999906 |  |  | 1781 | 0.9700000000000001 | 32.01000000000001
1781 | 33 | 32.34 | 0.9800000000000001 | 0.9700000000000001 | 32.01000000000001 | 0.3299999999999983 |  |  | 1782 | 0.9700000000000001 | 28.13
1782 | 29 | 28.42 | 0.9800000000000001 | 0.9700000000000001 | 28.13 | 0.2899999999999991 |  |  | 1782 | 0.9700000000000001 | 12.61
1782 | 13 | 12.74 | 0.98 | 0.9700000000000001 | 12.61 | 0.129999999999999 |  |  | 1779 | 0.9700000000000001 | 10.67
30102 | 1 | 3.71 | 3.71 | 3.29 | 3.29 | 0.4200000000000004 |  |  | 1779 | 0.9700000000000001 | 17.46
19415 | 75 | 149.25 | 1.99 | 1.99 | 149.25 | 0 |  |  | 1781 | 0.9700000000000001 | 9.700000000000001
19415 | 10 | 19.9 | 1.99 | 1.99 | 19.9 | 0 |  |  | 1782 | 0.9700000000000001 | 5.82
66015 | 87 | 173.13 | 1.99 | 1.99 | 173.13 | 0 |  |  | 1776 | 0.9700000000000001 | 23.28
66015 | 12 | 23.88 | 1.99 | 1.99 | 23.88 | 0 |  |  | 1777 | 0.9700000000000001 | 11.64
72015 | 97 | 193.03 | 1.99 | 1.99 | 193.03 | 0 |  |  | 1779 | 0.9700000000000001 | 11.64
72015 | 5 | 9.95 | 1.99 | 1.99 | 9.95 | 0 |  |  | 1776 | 0.9700000000000001 | 46.56
72215 | 221 | 517.14 | 2.34 | 2.34 | 517.14 | 0 |  |  |  |  | 341.44
72215 | 10 | 23.4 | 2.34 | 2.34 | 23.4 | 0 |  |  |  |  | Can these number be auto populated and grouped by bracket 1 unit price from data on the left?
72615 | 8 | 15.92 | 1.99 | 1.99 | 15.92 | 0
72715 | 25 | 49.75 | 1.99 | 1.99 | 49.75 | 0 |  |  | 19415 | 1.99 | 149.25
72715 | 10 | 19.9 | 1.99 | 1.99 | 19.9 | 0 |  |  | 19415 | 1.99 | 19.9
98815 | 11 | 21.89 | 1.99 | 1.99 | 21.89 | 0 |  |  | 66015 | 1.99 | 173.13
98815 | 1 | 1.99 | 1.99 | 1.99 | 1.99 | 0 |  |  | 66015 | 1.99 | 23.88
1779 | 11 | 10.78 | 0.98 | 0.9700000000000001 | 10.67 | 0.1099999999999977 |  |  | 72015 | 1.99 | 193.03
92194 | 32 | 63.68 | 1.99 | 0 | 0 | 63.68 |  |  | 72015 | 1.99 | 9.95
17760 | 10 | 9.8 | 0.9800000000000001 | 0 | 0 | 9.8 |  |  | 72615 | 1.99 | 15.92
1779 | 18 | 17.64 | 0.98 | 0.9700000000000001 | 17.46 | 0.1799999999999997 |  |  | 72715 | 1.99 | 49.75
1781 | 10 | 9.8 | 0.9800000000000001 | 0.9700000000000001 | 9.700000000000001 | 0.09999999999999964 |  |  | 72715 | 1.99 | 19.9
1782 | 6 | 5.88 | 0.98 | 0.9700000000000001 | 5.82 | 0.05999999999999961 |  |  | 98815 | 1.99 | 21.89
19415 | 18 | 35.82 | 1.99 | 1.99 | 35.82 | 0 |  |  | 98815 | 1.99 | 1.99
66015 | 17 | 33.83 | 1.99 | 1.99 | 33.83 | 0 |  |  | 19415 | 1.99 | 35.82
72015 | 7 | 13.93 | 1.99 | 1.99 | 13.93 | 0 |  |  | 66015 | 1.99 | 33.83
72215 | 16 | 37.44 | 2.34 | 2.34 | 37.44 | 0 |  |  | 72015 | 1.99 | 13.93
72715 | 52 | 103.48 | 1.99 | 1.99 | 103.48 | 0 |  |  | 72715 | 1.99 | 103.48
98815 | 16 | 31.84 | 1.99 | 1.99 | 31.84 | 0 |  |  | 98815 | 1.99 | 31.84
2 | 9 | 17.37 | 1.93 | 0 | 0 | 17.37 |  |  |  |  | 897.49
1776 | 24 | 23.52 | 0.98 | 0.9700000000000001 | 23.28 | 0.2399999999999984 |  |  |  |  | I don’t care about zeros because they are already being acounted in chargeback on top.
13418 | 95 | 219.45 | 2.31 | 0 | 0 | 219.45
1777 | 12 | 11.76 | 0.98 | 0.9700000000000001 | 11.64 | 0.1199999999999992 |  |  | 72215 | 2.34 | 37.44
1779 | 12 | 11.76 | 0.98 | 0.9700000000000001 | 11.64 | 0.1199999999999992 |  |  | 72215 | 2.34 | 517.14
1776 | 48 | 47.04 | 0.98 | 0.9700000000000001 | 46.56 | 0.4799999999999969 |  |  | 72215 | 2.34 | 23.4
 |  |  | 0 | 0 | 0 | 0 |  |  |  |  | 577.9799999999999
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 |  |  | 30102 | 3.29 | 3.29
 |  |  | 0 | 0 | 0 | 0 |  |  |  |  | 3.29
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
END