![]() |
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 |
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 |
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