How to sort more than one condition in excel

Hello,

I have a spreadsheet that determines quotes that need to be turned in there are several situations when the quotes have to be turned in such as raw material changes, cost increase for components, cost decrease for components, and new parts.
The colums look like this:
Qtry Alum MP Anual Steel SPS

What I need is something that will allow me to sort all of these colums taking into consideration that the conditions may apply to many parts. So I may have part number 66859545 and the part needs to be adjusted for Alum qtr it also has SPS changes and it also has MP changes. I need to be able to sort by all conditions that apply for each part how can I do this in excel 03. I tried putting Y and N for conditions that apply but the sort eliminates anything that does not aply with each sort and I know that there are more condition that apply to the parts.