How to sort an Excel spreadsheet by more than 3 columns?
 

Using Excel 2000.
Would like to sort approximately 500 row sheet by four columns.
SORT 1: Location column
SORT 2: Vendors used within the Location group
SORT 3: Purchase orders assigned to the Vendors
SORT 4: Breakdown of purchase orders by different account numbers.

How to sort an Excel spreadsheet by more than 3 columns?
 

First do a sort of all the data based only on your least important criterion
(account numbers). Then do the sort of the same data by your three top
criteria (location, vendors, POs).
The result will be as if you sorted all four together.

"William,Summit,Oh" wrote:

Using Excel 2000.
Would like to sort approximately 500 row sheet by four columns.
SORT 1: Location column
SORT 2: Vendors used within the Location group
SORT 3: Purchase orders assigned to the Vendors
SORT 4: Breakdown of purchase orders by different account numbers.

How to sort an Excel spreadsheet by more than 3 columns?
 

This worked great. And so simple. Thank you.

"bpeltzer" wrote:

First do a sort of all the data based only on your least important criterion
(account numbers). Then do the sort of the same data by your three top
criteria (location, vendors, POs).
The result will be as if you sorted all four together.

"William,Summit,Oh" wrote:

Using Excel 2000.
Would like to sort approximately 500 row sheet by four columns.
SORT 1: Location column
SORT 2: Vendors used within the Location group
SORT 3: Purchase orders assigned to the Vendors
SORT 4: Breakdown of purchase orders by different account numbers.