ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Sorting more than 3 columns - is it possible? (https://www.excelbanter.com/excel-programming/356618-sorting-more-than-3-columns-possible.html)

matpj[_48_]

Sorting more than 3 columns - is it possible?
 

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

--
matp
-----------------------------------------------------------------------
matpj's Profile: http://www.excelforum.com/member.php...fo&userid=2107
View this thread: http://www.excelforum.com/showthread.php?threadid=52471


Andrew Taylor

Sorting more than 3 columns - is it possible?
 
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

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

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

thanks in advance,

Matt


--
matpj
------------------------------------------------------------------------
matpj's Profile: http://www.excelforum.com/member.php...o&userid=21076
View this thread: http://www.excelforum.com/showthread...hreadid=524717




All times are GMT +1. The time now is 02:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com