SUBTOTAL Sort

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can you sort by Subtotal values but keep associated data together?

For instance, I sort data by part number. Then I subtotal the dollar values
(+/-)associated with each part number.

I then want to rank (i.e. sort) by the highest net dollar difference to the
lowest net dollar value based on the net SUBTOTAL values.
 
Try hiding the details--but keep the subtotal rows visible.

Then sort your data.

(I was pretty amazed when I saw this work--it was an accident!)
 

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

Additonal info into newly created Subtotal row 1
Copy summary data to new sheet 1
Subtotal of values in cells containing formula 1
How do I subtotal specific / random rows from a spreadsheet? 1
Putting subtotals in $ descending order 1
Excel - Sorting groups in groups due to subtotaling 2
Need help creating a running subtotal 2
Subtotals and Conditional Formatting 1

Back
Top