Sorting Grouped Data?

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
 
B

Bernie Simmonds

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
 
C

CLR

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
 
Top