ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Custom Sort Order (https://www.excelbanter.com/excel-discussion-misc-queries/171912-custom-sort-order.html)

Fishnerd

Custom Sort Order
 
Is there any way to make a custom Sort Order so that excel will sort
diiferently then the default? In other words, create some sort of rule that
it will follow instead of the default. Kind of like when excel sorts the
month names in month order instead of alphabetical order.

Thanks!

Jim Cone

Custom Sort Order
 

Make up your list on a worksheet.
Go to Tools | Options | Custom Lists and import and add.
When sorting you must specify the custom list - click the "options"
button in the Sort dialog box to do that.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming - check out Special Sort)



"Fishnerd"
wrote in message
Is there any way to make a custom Sort Order so that excel will sort
diiferently then the default? In other words, create some sort of rule that
it will follow instead of the default. Kind of like when excel sorts the
month names in month order instead of alphabetical order.

Thanks!

Fishnerd

Custom Sort Order
 
Thanks so much!

"Jim Cone" wrote:


Make up your list on a worksheet.
Go to Tools | Options | Custom Lists and import and add.
When sorting you must specify the custom list - click the "options"
button in the Sort dialog box to do that.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming - check out Special Sort)



"Fishnerd"
wrote in message
Is there any way to make a custom Sort Order so that excel will sort
diiferently then the default? In other words, create some sort of rule that
it will follow instead of the default. Kind of like when excel sorts the
month names in month order instead of alphabetical order.

Thanks!



All times are GMT +1. The time now is 06:00 AM.

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