View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] danielle.travers@gmail.com is offline
external usenet poster
 
Posts: 6
Default sorting by groups of rows

I have a spreadsheet that needs to be sorted based on several
conditions, but I need to keep certain rows grouped together.
Basically, here is a snapshot of what the sheet looks like:

Style ID Mat ID Color ID Total
8BN164 UPR F0AFB OH 2
8BN164 UPR F0AFB WSS 34.3
8BN164 UPR F0AFB Sold 1
8BN165 XN3 F0AEP OH 0
8BN165 XN3 F0AEP WSS 0
8BN165 XN3 F0AEP Sold 0
8BN165 UPF F0AEE OH 8
8BN165 UPF F0AEE WSS 137.1
8BN165 UPF F0AEE Sold 1


I will need to sort this sheet maintaining certain conditions. I need
the three rows of OH, WSS, and Sold to stay grouped together for each
Style/Mat/Color. Is this possible?

I really appreciate any help you can provide. Thanks!

Danielle