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

If I understand your question, nothing beyond using the Data | Sort
menu is required. Sort firstly on the OH/WSS/Sold column. Sort
secondly or higher on any other columns you want.

Hth,
Merjet

On May 3, 7:50 pm, merjet wrote:
If I understand your question, nothing beyond using the Data | Sort
menu is required. Sort firstly on the OH/WSS/Sold column. Sort
secondly or higher on any other columns you want.

Hth,
Merjet

I don't think I explained myself very well... the spreadsheet actually
has about 30 more columns, and the classifications that I need to sort
by are not included in the snapshot I provided (there wasn't space in
the post). So, if I sort by Group, Permanent/Sea, Material, and Color
(not shown in my snapshot) how do I keep the OH, WSS, and Sld in the
correct order?

You still haven't explained yourself well. :-) What does "in the
correct order" mean? I guess it doesn't mean all OH together, all WSS
together, all Sold together, since that is what my prior answer does.
So I will guess again. After being sorted otherwise, you want the
order to be OH, WSS, Sold. Since they aren't in alphabetic order,
maybe you need to add a dummy column which has 1 if OH, 2 if WSS, or 3
if Sold, and use that as your last sort criteria.

Hth,
Merjet

I'd do what merjet suggested.

But another option would be to create a custom list that you could sort by.

Tools|Options|Custom Lists tab

Then use that as the sequence when you do the sort (click on the Options button
on the data|sort dialog).

merjet wrote:

You still haven't explained yourself well. :-) What does "in the
correct order" mean? I guess it doesn't mean all OH together, all WSS
together, all Sold together, since that is what my prior answer does.
So I will guess again. After being sorted otherwise, you want the
order to be OH, WSS, Sold. Since they aren't in alphabetic order,
maybe you need to add a dummy column which has 1 if OH, 2 if WSS, or 3
if Sold, and use that as your last sort criteria.

Hth,
Merjet

--

Dave Peterson