How to sort data with rows that have subtotals
 

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 |
+-------------------------------------------------------------------+

--
nander
------------------------------------------------------------------------
nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156
View this thread: http://www.excelforum.com/showthread...hreadid=507313