ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sort 4 Columns (https://www.excelbanter.com/excel-discussion-misc-queries/196419-sort-4-columns.html)

dot

Sort 4 Columns
 
I want to sort 4 columns of data. A thru D. I want to sort by B then C then
D then A. Is this possible. The data sort feature only lets you do 3 at a
time.

Dave Peterson

Sort 4 Columns
 
Do the sort twice.

The first sort with one key--the most minor.

The second sort with the other 3 keys.

Dot wrote:

I want to sort 4 columns of data. A thru D. I want to sort by B then C then
D then A. Is this possible. The data sort feature only lets you do 3 at a
time.


--

Dave Peterson

dot

Sort 4 Columns
 
I thought there was a modification that could be done to the sort tool, but
doing it twice will work. Thanks

"Dave Peterson" wrote:

Do the sort twice.

The first sort with one key--the most minor.

The second sort with the other 3 keys.

Dot wrote:

I want to sort 4 columns of data. A thru D. I want to sort by B then C then
D then A. Is this possible. The data sort feature only lets you do 3 at a
time.


--

Dave Peterson



All times are GMT +1. The time now is 04:26 AM.

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