Shaunl,

Try sorting by your 4th criterion, then sort again by the 1st, 2nd, and 3rd.
The integrity of the first sort (4th criterion) 4th criteria sort should be
retained.

HTH,
Ryan

"shaunl" wrote:


Hi everyone,
I have a worksheet where I have to sort data in four columns, yet excel
provides the options (Data Sort) to only sort 3 columns.

Are there options to sort through more columns?

I need to be able to sort in the order of the four columns and the file
can be found here -
http://www.waratahs.com.au/DrawsandC...r-DOWNLOAD.xls
The data to be sorted is between B5-O16 and then sorted in the
following order:
1. PTS - Descending
2. W - Descending
3. L - Ascending
4. % - Descending

How do I do this? Any help would be great.

Cheers


--
shaunl
------------------------------------------------------------------------
shaunl's Profile: http://www.excelforum.com/member.php...o&userid=25140
View this thread: http://www.excelforum.com/showthread...hreadid=560133