Spreadsheet: 843379d1695234796-price-adjustment-based-on-quantity-and-matching-item-names-excel-forum-18-september-hasan-mougharbel-
Sheet: Sheet1

 | CTN # | Item no. | order no. | Line Item Name (Product Title + Options) | QTY | QTY in CTN | Price $/item | Total / Item
 | 1 | 94761-07-02 | # 1143 | [NAME] Pants | 3 |  |  | 40.49
 |  | 94761-06-02 | # 1143 | [NAME] Pants | 5 |  |  | 67.49
 |  | 94761-05-02 | # 1143 | [NAME] Pants | 5 |  |  | 67.49
 |  | 94761-04-02 | # 1143 | [NAME] Pants | 5 |  |  | 67.49
 |  | 94761-03-02 | # 1143 | [NAME] Pants | 5 |  |  | 67.49
 | 2 | 94761-07-03 | # 1143 | [NAME] Pants | 5 |  |  | 67.49
 |  | 94761-06-03 | # 1143 | [NAME] Pants | 5 |  |  | 67.49
 |  | 94761-05-03 | # 1143 | [NAME] Pants | 5 |  |  | 67.5
 |  | 94761-04-03 | # 1143 | [NAME] Pants | 5 |  |  | 67.5
 |  | 94761-03-03 | # 1143 | [NAME] Pants | 5 |  |  | 67.5
 | 3 | 96378-03-01 | # 41338 | MEN-ESSENTIAL-STRINGER (BLACK) | 4 |  |  | 44.88
 |  | 96378-04-01 | # 41338 | MEN-ESSENTIAL-STRINGER (BLACK) | 5 |  |  | 56.1
 |  | 96378-05-01 | # 41338 | MEN-ESSENTIAL-STRINGER (BLACK) | 5 |  |  | 56.1
 |  | 96378-06-01 | # 41338 | MEN-ESSENTIAL-STRINGER (BLACK) | 5 |  |  | 56.1
 |  | 96378-07-01 | # 41338 | MEN-ESSENTIAL-STRINGER (BLACK) | 5 |  |  | 56.1
 |  | 96379-03-08 | # 41338 | MEN-ESSENTIAL-REGULAR FIT -T-SHIRT (WHITE) | 5 |  |  | 68.85
 |  | 96379-04-08 | # 41338 | MEN-ESSENTIAL-REGULAR FIT -T-SHIRT (WHITE) | 5 |  |  | 68.85
 |  | 96379-05-08 | # 41338 | MEN-ESSENTIAL-REGULAR FIT -T-SHIRT (WHITE) | 5 |  |  | 68.85
 |  | 96379-03-179 | # 41338 | MEN-ESSENTIAL-REGULAR FIT -T-SHIRT (TOMATO-DARK RED) | 5 |  |  | 68.85
 |  | 96379-04-179 | # 41338 | MEN-ESSENTIAL-REGULAR FIT -T-SHIRT (TOMATO-DARK RED) | 5 |  |  | 68.85
 |  | 96379-05-179 | # 41338 | MEN-ESSENTIAL-REGULAR FIT -T-SHIRT (TOMATO-DARK RED) | 5 |  |  | 68.85
 |  | 96379-06-179 | # 41338 | MEN-ESSENTIAL-REGULAR FIT -T-SHIRT (TOMATO-DARK RED) | 5 |  |  | 68.85
 | 4 | 96379-07-179 | # 41338 - 41246 | MEN-ESSENTIAL-REGULAR FIT -T-SHIRT (TOMATO-DARK RED) | 6 |  |  | 68.85
 |  | 96378-03-08 | # 41338 - 41246 | MEN-ESSENTIAL-STRINGER (WHITE) | 4 |  |  | 44.88
 |  | 96378-04-08 | # 41338 - 41246 | MEN-ESSENTIAL-STRINGER (WHITE) | 5 |  |  | 56.1
 |  | 96378-05-08 | # 41338 - 41246 | MEN-ESSENTIAL-STRINGER (WHITE) | 5 |  |  | 56.1
 |  | 96378-06-08 | # 41338 - 41246 | MEN-ESSENTIAL-STRINGER (WHITE) | 5 |  |  | 56.1
 |  | 96378-07-08 | # 41338 - 41246 | MEN-ESSENTIAL-STRINGER (WHITE) | 5 |  |  | 56.1
 |  | 96380-03-08 | # 41338 - 41246 | MEN-ESSENTIAL-TANK (WHITE) | 4 |  |  | 40.8
 |  | 96380-04-08 | # 41338 - 41246 | MEN-ESSENTIAL-TANK (WHITE) | 5 |  |  | 51
 |  | 96380-05-08 | # 41338 - 41246 | MEN-ESSENTIAL-TANK (WHITE) | 5 |  |  | 51
 |  | 96380-06-08 | # 41338 - 41246 | MEN-ESSENTIAL-TANK (WHITE) | 5 |  |  | 51
 |  | 96380-07-08 | # 41338 - 41246 | MEN-ESSENTIAL-TANK (WHITE) | 5 |  |  | 51
 |  | 94085-05-01 | # 41338 - 41246 | MEN ATHLES PANTS(BLACK) | 2 |  |  | 0
 |  | 95713-08-14 | # 41338 - 41246 | MEN LEGACY PANTS(DARK-GREY) | 1 |  |  | 0
 |  | 95812-07-04 | # 41338 - 41246 | MEN STRONGER LONG SLEEVE T-SHIRT(GREY) | 1 |  |  | 0
 |  | 96088-07-01 | # 41338 - 41246 | MEN [NAME] T-SHIRT LONG SLEEVE (BLACK) | 1 |  |  | 0
 |  | 95983-08-01 | # 41338 - 41246 | MEN BLACK PANT(BLACK) | 1 |  |  | 0
 |  | 95846-08-01 | # 41338 - 41246 | MEN FALCON ZIP JACKET(BLACK) | 1 |  |  | 0
 |  | 95807-07-08 | # 41338 - 41246 | MEN WRECKED TSHIRT(WHITE) | 1 |  |  | 0
 | 5 | 96433-03-01 | # 41454 | MEN-ESSENTIAL-OVERSIZE T-SHIRT (BLACK) | 5 |  |  | 76.5
 |  | 96433-04-01 | # 41454 | MEN-ESSENTIAL-OVERSIZE T-SHIRT (BLACK) | 5 |  |  | 76.5
 |  | 96433-05-01 | # 41454 | MEN-ESSENTIAL-OVERSIZE T-SHIRT (BLACK) | 5 |  |  | 76.5
 |  | 96433-06-01 | # 41454 | MEN-ESSENTIAL-OVERSIZE T-SHIRT (BLACK) | 5 |  |  | 76.5
 |  | 96433-03-98 | # 41454 | MEN-ESSENTIAL-OVERSIZE T-SHIRT (Marl-Dark-Grey) | 5 |  |  | 76.5
 |  | 96433-04-98 | # 41454 | MEN-ESSENTIAL-OVERSIZE T-SHIRT (Marl-Dark-Grey) | 5 |  |  | 76.5
 |  | 96433-05-98 | # 41454 | MEN-ESSENTIAL-OVERSIZE T-SHIRT (Marl-Dark-Grey) | 5 |  |  | 76.5
 | 6 | 96433-06-98 | # 41454 | MEN-ESSENTIAL-OVERSIZE T-SHIRT (Marl-Dark-Grey) | 5 |  |  | 76.5
 |  | 96433-03-221 | # 41454 | MEN-ESSENTIAL-OVERSIZE T-SHIRT (Green) | 5 |  |  | 76.5
 |  | 96433-04-221 | # 41454 | MEN-ESSENTIAL-OVERSIZE T-SHIRT (Green) | 5 |  |  | 76.5
 |  | 96433-05-221 | # 41454 | MEN-ESSENTIAL-OVERSIZE T-SHIRT (Green) | 5 |  |  | 76.5
 |  | 96433-06-221 | # 41454 | MEN-ESSENTIAL-OVERSIZE T-SHIRT (Green) | 5 |  |  | 76.5
 |  | 96433-03-172 | # 41454 | MEN-ESSENTIAL-OVERSIZE T-SHIRT (Dark-Red) | 5 |  |  | 76.5
 |  | 96433-04-172 | # 41454 | MEN-ESSENTIAL-OVERSIZE T-SHIRT (Dark-Red) | 5 |  |  | 76.5
 | 7 | 96433-05-172 | # 41454 | MEN-ESSENTIAL-OVERSIZE T-SHIRT (Dark-Red) | 5 |  |  | 76.5
 |  | 96433-06-172 | # 41454 | MEN-ESSENTIAL-OVERSIZE T-SHIRT (Dark-Red) | 5 |  |  | 76.5
 |  | 96433-03-175 | # 41454 | MEN-ESSENTIAL-OVERSIZE T-SHIRT (Marl-Light-Grey) | 5 |  |  | 76.5
 |  | 96433-04-175 | # 41454 | MEN-ESSENTIAL-OVERSIZE T-SHIRT (Marl-Light-Grey) | 5 |  |  | 76.5
 |  | 96433-05-175 | # 41454 | MEN-ESSENTIAL-OVERSIZE T-SHIRT (Marl-Light-Grey) | 5 |  |  | 76.5
 |  | 96433-06-175 | # 41454 | MEN-ESSENTIAL-OVERSIZE T-SHIRT (Marl-Light-Grey) | 5 |  |  | 76.5