Sorting more than 3 columns

Sorting more than 3 columns - is it possible?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

matpj - 21 Mar 2006 10:54 GMT

Hi there, can anyone tell me if its possible to sort by more than
columns.

I have 5 that i'd need to sort, but mmanually there is a limit of
columns.
I was hoping that with VBA I could include some more, but it doesn'
seem to work...

thanks in advance,

Mat

Reply to this Message

Andrew Taylor - 21 Mar 2006 11:22 GMT

You can do this by sorting by the last two columns first, and then
by the first 3 - see
http://support.microsoft.com/?kbid=268007

Andrew

> Hi there, can anyone tell me if its possible to sort by more than 3
> columns.
[quoted text clipped - 13 lines]
> matpj's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21076
> View this thread: http://www.excelforum.com/showthread.php?threadid=524717

Reply to this Message