Custom Sort

[ThaNguyen]

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

[Ago]

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]

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]

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

[mikerickson]

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]

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]

And how do I that exactly?

Never mind figured it out.

Thanks