N
nander
In this excel file I have items with sales history that total at the end
of the group of like items. On the left of the spreadsheet, outside the
working space, there are the numbers 1 2 3 and + to expand the rows to
the totals. How do I strip out the sub items and get the sku by the
total row? I uploaded the file.
Sku Description Qty Qty
1000G 1000G 3/4"X100' 30GA HNG STP W/ HOLES 30 30
1000G 1000G 3/4"X100' 30GA HNG STP W/ HOLES 10 10
1000G 1000G 3/4"X100' 30GA HNG STP W/ HOLES 30 30
1000G 1000G 3/4"X100' 30GA HNG STP W/ HOLES 50 50
1000G 1000G 3/4"X100' 30GA HNG STP W/ HOLES 20 20
1000G 1000G 3/4"X100' 30GA HNG STP W/ HOLES 10 10
1000G 1000G 3/4"X100' 30GA HNG STP W/ HOLES 20 20
1000G 1000G 3/4"X100' 30GA HNG STP W/ HOLES 20 20
1000G 1000G 3/4"X100' 30GA HNG STP W/ HOLES 10 10
1000G 3/4"X100' 30GA HNG STP W/ HOLES Total200 200
I was
+-------------------------------------------------------------------+
|Filename: Product mix.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4296 |
+-------------------------------------------------------------------+
of the group of like items. On the left of the spreadsheet, outside the
working space, there are the numbers 1 2 3 and + to expand the rows to
the totals. How do I strip out the sub items and get the sku by the
total row? I uploaded the file.
Sku Description Qty Qty
1000G 1000G 3/4"X100' 30GA HNG STP W/ HOLES 30 30
1000G 1000G 3/4"X100' 30GA HNG STP W/ HOLES 10 10
1000G 1000G 3/4"X100' 30GA HNG STP W/ HOLES 30 30
1000G 1000G 3/4"X100' 30GA HNG STP W/ HOLES 50 50
1000G 1000G 3/4"X100' 30GA HNG STP W/ HOLES 20 20
1000G 1000G 3/4"X100' 30GA HNG STP W/ HOLES 10 10
1000G 1000G 3/4"X100' 30GA HNG STP W/ HOLES 20 20
1000G 1000G 3/4"X100' 30GA HNG STP W/ HOLES 20 20
1000G 1000G 3/4"X100' 30GA HNG STP W/ HOLES 10 10
1000G 3/4"X100' 30GA HNG STP W/ HOLES Total200 200
I was
+-------------------------------------------------------------------+
|Filename: Product mix.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4296 |
+-------------------------------------------------------------------+