sort with 4 parameters

  • Thread starter Thread starter Hal
  • Start date Start date
H

Hal

Hi,

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

Thanks!
Hal
 
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
 
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top