Sorting a table on 2 columns
 

Hi,
I need to sort the following data in A2:C8 to E2:G8 (actually there are 40
rows of data). The date needs to be sorted to Low risk first (then mid and
high) and then by descending sales in each category of risk.

A B C D E F G
1 Risk Name Sales Risk Name Sales
2 Mid Joe 240 Low Mary 630
3 High Jack 540 Low Josh 234
4 Low Mary 630 Mid Joe 240
5 Low John 76 Mid Carol 136
6 High Bess 120 Low John 76
7 Low Josh 234 High Jack 540
8 Mid Carol 136 High Bess 120

I need a function solution as the spreadsheet will be various hands and not
all are comfortable with running macros, pivots or filters.

Many Thanks, Christian

Sorting a table on 2 columns
 

See your other posts, I already responded.

Please do not multipost.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Christian" wrote:

Hi,
I need to sort the following data in A2:C8 to E2:G8 (actually there are 40
rows of data). The date needs to be sorted to Low risk first (then mid and
high) and then by descending sales in each category of risk.

A B C D E F G
1 Risk Name Sales Risk Name Sales
2 Mid Joe 240 Low Mary 630
3 High Jack 540 Low Josh 234
4 Low Mary 630 Mid Joe 240
5 Low John 76 Mid Carol 136
6 High Bess 120 Low John 76
7 Low Josh 234 High Jack 540
8 Mid Carol 136 High Bess 120

I need a function solution as the spreadsheet will be various hands and not
all are comfortable with running macros, pivots or filters.

Many Thanks, Christian