Sorting - why can you only sort by 3 columns?

lars

Board Regular
Joined
Mar 27, 2002
Messages
105
Is there a way to sort data by more than the three columns in the sort option....Lotus 123 had more fields to choose 5 years ago.
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Hi,

No way to sort on more than three in one shot. One workaround is to sort on the least important columns first.

1. Sort on columns D and E, for instance
2. Then sort on columns A,B, and C which are your highest priority sorts.

Bye,
Jay
 
Upvote 0
On 2002-04-25 10:45, lars wrote:
Is there a way to sort data by more than the three columns in the sort option....Lotus 123 had more fields to choose 5 years ago.

If you want to sort based on 5 columns just do it in 2 passes. For example, first sort on columns C, D and E. Next, sort on columns A and B. That's the same as sorting on columns A, B, C, D and E.
 
Upvote 0
That's the way i do it but I was hoping for something else.

Thanks for the advice
 
Upvote 0
On 2002-04-25 11:16, lars wrote:
That's the way i do it but I was hoping for something else.

Thanks for the advice

If each of your columns contained the same data type you could also concatenate the 5 values together on each row and sort on that combined column. For example...

=A2&","&B2&","&C2&","&D2&","&E2
This message was edited by Mark W. on 2002-04-25 11:28
 
Upvote 0

Forum statistics

Threads
1,213,562
Messages
6,114,326
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top