How to sort data with rows that have subtotals

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how Sum if left (3 digits) are the equal to a field? 0
Look up 1 value and return a set of values 0
How do I have excel highlight days before & after a date on a cale 2
How to create percentages for the combined rows? 1
Running Sum? 2
Adding intermittent rows to a spread sheet 2
Convert Row/Column data to Database 3
type mismatch error in macro in excel 0

Top