Order Values

[Greg777]

Hello Excel Forum!

I've attached a workbook with 3 examples to work with.

I need to know how to order values and display them as shown in column F.

Null values should be excluded.
Column A is sorted ascending, then column B, then column C based upon the values in the table.

Where (e.g.) 'Scenario 3' has,
Column A {c=1,e=1}
Column B {c=1,e=1}
Column C {c=3,e=2}

And so the values in column A aren't determinate of the order, nor column B, but column C determines that the order is {e,c}.

I'm not sure how to achieve this for the resulting order (as shown in column F). Any help very much appreciated!

Greg

[rcm]

I used the custom sort with 3 levels A,B,C

[Greg777]

Thanks for the reply. I don't think I have that custom function. Would you post the code or attach the workbook that you used please?

[rcm]

Attached is your workbook with the sorted scenarios on the right.

choose the range: for the first scenario it would be A2:D7 by highlighting over it

Then, in the [home tab] look for [sort and filter] and then click the [custom sort] option

First level is the column B range (in this case each senario was dealt separately)
Second level is the column C range
Third level is the column D range

Click OK and the result should look like the data in H2:j7 in the workbook

I presume that Excel 2003 has at least 3 levels of sorting.

Cheers,

[Greg777]

I made an oversight in defining this question. Thanks for the excellent answer that you provided for the question that I asked. I need the resulting column to be ordered whenever one of the values in columns A-E change automatically. I posted it under excel programming, but forgot to include that important part. This is actually an abstraction of my problem, and I intend to apply the help here to several changing data sets across many workbooks. Hopefully someone can show me how this problem can be answered automatically (and without manually initializing a macro).

[rcm]

yes there is a worksheet_change() macro that will execute upon a change in the data automatically. You will just have to adjust the actual range. I will witre the macro and send it to you.

[rcm]

here it goes try changing the values in sample 1 in columns h:k