Sorting
 

Is there a way to sort more then 3 columns or have more then 3 criteria to
sort on? I currently have 7 and usually I just parse the data but would
prefer to simply sort on the original set, thx.

Sorting
 

Not directly. Per "Excel limits & specifications"
"Sort references: 3 in a single sort; unlimited when using sequential sorts "

However, you could record a macro of your sort (sequentially) and make this
a custom button on a toolbar, if you want.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Darin" wrote:

Is there a way to sort more then 3 columns or have more then 3 criteria to
sort on? I currently have 7 and usually I just parse the data but would
prefer to simply sort on the original set, thx.

Sorting
 

Sort them 3 at a time, sorting by the least significant group first.

If you have 7 columns A to G in decreasing order of significance, select the
whole range then for your first sort, choose sort by E then F then G.
Then sort again by B then C then D.
Then sort again just by A.
Just make sure that in each case you have the whole range selected before
you sort.
--
David Biddulph

"Darin" wrote in message
...
Is there a way to sort more then 3 columns or have more then 3 criteria to
sort on? I currently have 7 and usually I just parse the data but would
prefer to simply sort on the original set, thx.