View Full Version : Custom Sort
ThaNguyen
06-16-2008, 11:31 AM
Hi all,
I have a query table with a month sorted 1,2,3,4.....12
Is there a way I can sort by 7,8,9,10,11,12,1,2,3,4,5,6
Thank you
i dont think you can make excel do it, but since its only 12 lines/columns we are talking about it shouldnt be so hard to make a own sortengine.
grichey
06-16-2008, 11:59 AM
Or hide a column with relative numbers in that columns ie put your current months in b1 ,b 2, ... b12 : 7 , 8, 6 respectively and in a1, a2, a12 put 1, 2, 12 and just set your sort to that column. and hide it.
ThaNguyen
06-16-2008, 12:35 PM
Or hide a column with relative numbers in that columns ie put your current months in b1 ,b 2, ... b12 : 7 , 8, 6 respectively and in a1, a2, a12 put 1, 2, 12 and just set your sort to that column. and hide it.
That's what I did for now. I thought there might be something in excel or VBA that could be possible.
Thank you for the inputs :friends:
mikerickson
06-16-2008, 12:44 PM
You could use Excel Options to define a custom List 7,8,9,10,11,12,1,2,3,4,5,6
and then tell Excel's Sort to use that order
ThaNguyen
06-16-2008, 12:50 PM
You could use Excel Options to define a custom List 7,8,9,10,11,12,1,2,3,4,5,6
and then tell Excel's Sort to use that order
And how do I that exactly?
ThaNguyen
06-16-2008, 12:53 PM
And how do I that exactly?
Never mind figured it out.
Thanks
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.