software

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.
SkuDescriptionQtyQty
1000G1000G 3/4quot;X100' 30GA HNG STP W/ HOLES3030
1000G1000G 3/4quot;X100' 30GA HNG STP W/ HOLES1010
1000G1000G 3/4quot;X100' 30GA HNG STP W/ HOLES3030
1000G1000G 3/4quot;X100' 30GA HNG STP W/ HOLES5050
1000G1000G 3/4quot;X100' 30GA HNG STP W/ HOLES2020
1000G1000G 3/4quot;X100' 30GA HNG STP W/ HOLES1010
1000G1000G 3/4quot;X100' 30GA HNG STP W/ HOLES2020
1000G1000G 3/4quot;X100' 30GA HNG STP W/ HOLES2020
1000G1000G 3/4quot;X100' 30GA HNG STP W/ HOLES1010
1000G 3/4quot;X100' 30GA HNG STP W/ HOLES Total200200

I was -------------------------------------------------------------------
|Filename: Product mix.zip |
|Download: www.excelforum.com/attachment.php?postid=4296 |
-------------------------------------------------------------------

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