Sorting Subtotaled and Sorted Groups of Data

GerberC

New Member
Joined
Oct 17, 2006
Messages
2
I have multiple lines of data that have been sorted by Inventory Number then date. I then subtotaled by Inventory number. I want to now sort the inventory number subtotaled groups by date without losing the integrityof the subtotaled groups. Possible?
[/url]
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
I'm not sure I fully understand, but wouldn't you get that result by sorting by date then by inventory number before adding subtotals?
 

GerberC

New Member
Joined
Oct 17, 2006
Messages
2
I have mutliple dates and costs associated with each Inventory number, the costs are subtotaled. The subtotaled Inventory Numbers are now listed Alpha. I would like to sort the subtotaled groups by the oldest date within each group.
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
It might be easier to understand if you posted a small but representative sample of your data using Colo's utility below.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,888
Messages
5,574,842
Members
412,620
Latest member
sharma7s
Top