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

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

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,184
Messages
5,570,739
Members
412,338
Latest member
ebf6543
Top