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

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

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,111,910
Messages
5,541,538
Members
410,547
Latest member
htran4
Top