juicingbybonds
New Member
- Joined
- Jul 21, 2015
- Messages
- 1
Hello,
I am currently using Microsoft Excel 2007. I have downloaded a sales report from Amazon for my listings. What I am trying to do is figure out net sales for one specific product. I've removed all the products I didn't need from the sales report, here's the tricky part. The orders are broken up into 2 different cells on is the seller fees and then another for shipping fees. However the shipping fees do not have a product description only an order ID. What I want to try and do is have excel filter the results that have the same order # for example:
<tbody>
</tbody>
<tbody>
</tbody>
Instead of having to do a " find all " and search through every transaction - sorry if it's a bit confusing hope you can understand what I am trying to accomplish. I appreciate any help. Thanks.
I am currently using Microsoft Excel 2007. I have downloaded a sales report from Amazon for my listings. What I am trying to do is figure out net sales for one specific product. I've removed all the products I didn't need from the sales report, here's the tricky part. The orders are broken up into 2 different cells on is the seller fees and then another for shipping fees. However the shipping fees do not have a product description only an order ID. What I want to try and do is have excel filter the results that have the same order # for example:
type | order id | sku | description |
Order | 115-3915740-1705857 | ES-VKMB-7O7B | Drone |
<tbody>
</tbody>
Shipping Services | 115-3915740-1705857 | Shipping Label Purchased through Amazon |
<tbody>
</tbody>
Instead of having to do a " find all " and search through every transaction - sorry if it's a bit confusing hope you can understand what I am trying to accomplish. I appreciate any help. Thanks.
Last edited: