| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I format a column in alpha order? | New Users to Excel | |||
| Blank Spaces on Sort | Excel Discussion (Misc queries) | |||
| How can I sort multiple times | Excel Worksheet Functions | |||
| Sort range changes during sort | Excel Discussion (Misc queries) | |||
| Data > Sort function amnesia? | Excel Discussion (Misc queries) | |||
Threaded Mode
