View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
shaunl shaunl is offline
external usenet poster
 
Posts: 1
Default More sort options - do they exist?


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