Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to expand sort function beyond 3 on excel
Hello;
I am working on an excel ( Office 2003 ) spread sheet to develope a golf tournamant scoring sheet. One of the functions that I am trying to achieve is to sort the gross and net scores in order. Currently I have a Macro set up to sort the gross and net scores on two separate sheets. The problem is that will over 100 golfers there are situations where several golfers can have the same score so I have set up a three sort function where ties are broken by looking at two different individual hole scores. Doing a test of the spread sheet showed that some ties still exist so I want to expand the data sort function beyond the excel default of three. Any suggests would be greatly appreiciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent SORT from asking to expand selection in Excel 2007? | Excel Discussion (Misc queries) | |||
sort & expand trouble | Excel Discussion (Misc queries) | |||
HOW CAN I EXPAND A RANGE IN A FUNCTION BEYOND 30 CELLS IN EXCEL? | Excel Discussion (Misc queries) | |||
Named ranges wont expand after sort?? | Excel Programming | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions |