Sorting Grouped Data?

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

Hi,

I have a sales spreadsheet that is grouped by vendor with customer sales
info under each vendor. Is there a way to sort the vendor groups
keeping the customer data in each groups as is?

TIA,
Dan
 
This may work Dan.

To sort in Excel all the lines need to have same columns to sort on. So
a heading line and a space between Vendor Groups would be be a problem

You could add 2 columns (In the Example below columns A and B) with sort
data criteria so that the Heading and Space positions could be preserved.

Column A defines the Vendor Group
Column B defines the sort priority

Then Sort by Column A / B / C
Don't print Columns A and B

A B C
1 Vendor1Code A Vendor 1 Group Heading
2 Vendor1Code B Vendor X 1
3 Vendor1Code B Vendor X 2
4 Vendor1Code C (Blank Line)
5 Vendor2Code A Vendor 2 Group Heading
6 Vendor2Code B Vendor Y 1
7 Vendor2Code B Vendor Y 2
8 Vendor2Code C (Blank Line)



Bernie Simmonds
 
It kinda-sorta depends on why you want the sorts, and what else you might
want to do with them..........I think either the Data > Filter >
AutoFilter...........or the Data > SubTotals features might be of interest
to you............

Vaya con Dios,
Chuck, CABGx3
 
Back
Top