ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   sort with 4 parameters (https://www.excelbanter.com/excel-discussion-misc-queries/170910-sort-4-parameters.html)

Hal

sort with 4 parameters
 
Hi,

Current data sort allows for 3 parameters to sort with. Is there a way to
sort with 4 or more paramters.

Thanks!
Hal

carlo

sort with 4 parameters
 
Hi Hal

Make a hidden column, where you concatenate 2 or more columns, and
then sort after this one, should do the trick.

Cheers Carlo


On Dec 28, 11:07*am, Hal wrote:
Hi,

Current data sort allows for 3 parameters to sort with. Is there a way to
sort with 4 or more paramters.

Thanks!
Hal



RagDyeR

sort with 4 parameters
 
All you have to do is sort twice.

Start off in reverse, with the *least* important parameter first, and work
your way up in significance.

You can do 3, then 1,
OR
2 and 2,
OR
1 and 3.

You can sort with as many criteria as you need.
You're just restricted to doing it a max of 3 at a time!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"Hal" wrote in message
...
Hi,

Current data sort allows for 3 parameters to sort with. Is there a way to
sort with 4 or more paramters.

Thanks!
Hal





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

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