ExcelBanter - sort by more than 3 columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - sort by more than 3 columns (https://www.excelbanter.com/excel-worksheet-functions/25050-sort-more-than-3-columns.html)

jenn

sort by more than 3 columns

How can I sort by a, then b, then c, then d, e...?

CarlosAntenna

sort first by a, b, c
then sort again by d, e

-- Carlos

"jenn" wrote in message
...
How can I sort by a, then b, then c, then d, e...?

Dana DeLouis

How to sort more than three columns in Excel
http://support.microsoft.com/default...b;en-us;268007

HTH :)
--
Dana DeLouis
Win XP & Office 2003

"jenn" wrote in message
...

How can I sort by a, then b, then c, then d, e...?

Peo Sjoblom

Sort by the least significant column first, so if you would sort A:D, select
A:D, sort by column D, select A:D then sort again by A, B and C

Regards,

Peo Sjoblom

"jenn" wrote:

How can I sort by a, then b, then c, then d, e...?

All times are GMT +1. The time now is 03:33 AM.