I have a sheet with a couple of columns.
[TABLE="width: 163"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]IndexID[/TD]
[TD]Part Number[/TD]
[/TR]
[TR]
[TD]1,1[/TD]
[TD="align: right"]3807[/TD]
[/TR]
[TR]
[TD]1,2[/TD]
[TD="align: right"]6680[/TD]
[/TR]
[TR]
[TD]1,3[/TD]
[TD="align: right"]4440[/TD]
[/TR]
[TR]
[TD]1,4[/TD]
[TD="align: right"]2074[/TD]
[/TR]
[TR]
[TD]1,5[/TD]
[TD="align: right"]5021[/TD]
[/TR]
[TR]
[TD]1,6[/TD]
[TD="align: right"]2298[/TD]
[/TR]
[TR]
[TD]1,7[/TD]
[TD="align: right"]1572[/TD]
[/TR]
[TR]
[TD]1,8[/TD]
[TD="align: right"]3379[/TD]
[/TR]
[TR]
[TD]1,9[/TD]
[TD="align: right"]8832[/TD]
[/TR]
[TR]
[TD]1,10[/TD]
[TD="align: right"]2627[/TD]
[/TR]
[TR]
[TD]1,11[/TD]
[TD="align: right"]6802[/TD]
[/TR]
[TR]
[TD]1,12[/TD]
[TD="align: right"]4395[/TD]
[/TR]
[TR]
[TD]2,1[/TD]
[TD="align: right"]7504[/TD]
[/TR]
[TR]
[TD]2,2[/TD]
[TD="align: right"]4109[/TD]
[/TR]
[TR]
[TD]2,3[/TD]
[TD="align: right"]9803[/TD]
[/TR]
[TR]
[TD]2,4[/TD]
[TD="align: right"]5461[/TD]
[/TR]
[TR]
[TD]2,5[/TD]
[TD="align: right"]2052[/TD]
[/TR]
[TR]
[TD]2,6[/TD]
[TD="align: right"]2779[/TD]
[/TR]
[TR]
[TD]2,7[/TD]
[TD="align: right"]3397[/TD]
[/TR]
[TR]
[TD]2,8[/TD]
[TD="align: right"]7861[/TD]
[/TR]
[TR]
[TD]2,9[/TD]
[TD="align: right"]8898[/TD]
[/TR]
[TR]
[TD]2,10[/TD]
[TD="align: right"]9587[/TD]
[/TR]
[TR]
[TD]2,11[/TD]
[TD="align: right"]3924[/TD]
[/TR]
[TR]
[TD]2,12[/TD]
[TD="align: right"]6043[/TD]
[/TR]
</tbody>[/TABLE]
When I sort by Part number, I get the following:
[TABLE="width: 163"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]IndexID[/TD]
[TD]Part Number[/TD]
[/TR]
[TR]
[TD]1,7[/TD]
[TD="align: right"]1572[/TD]
[/TR]
[TR]
[TD]2,5[/TD]
[TD="align: right"]2052[/TD]
[/TR]
[TR]
[TD]1,4[/TD]
[TD="align: right"]2074[/TD]
[/TR]
[TR]
[TD]1,6[/TD]
[TD="align: right"]2298[/TD]
[/TR]
[TR]
[TD]1,10[/TD]
[TD="align: right"]2627[/TD]
[/TR]
[TR]
[TD]2,6[/TD]
[TD="align: right"]2779[/TD]
[/TR]
[TR]
[TD]1,8[/TD]
[TD="align: right"]3379[/TD]
[/TR]
[TR]
[TD]2,7[/TD]
[TD="align: right"]3397[/TD]
[/TR]
[TR]
[TD]1,1[/TD]
[TD="align: right"]3807[/TD]
[/TR]
[TR]
[TD]2,11[/TD]
[TD="align: right"]3924[/TD]
[/TR]
[TR]
[TD]2,2[/TD]
[TD="align: right"]4109[/TD]
[/TR]
[TR]
[TD]1,12[/TD]
[TD="align: right"]4395[/TD]
[/TR]
[TR]
[TD]1,3[/TD]
[TD="align: right"]4440[/TD]
[/TR]
[TR]
[TD]1,5[/TD]
[TD="align: right"]5021[/TD]
[/TR]
[TR]
[TD]2,4[/TD]
[TD="align: right"]5461[/TD]
[/TR]
[TR]
[TD]2,12[/TD]
[TD="align: right"]6043[/TD]
[/TR]
[TR]
[TD]1,2[/TD]
[TD="align: right"]6680[/TD]
[/TR]
[TR]
[TD]1,11[/TD]
[TD="align: right"]6802[/TD]
[/TR]
[TR]
[TD]2,1[/TD]
[TD="align: right"]7504[/TD]
[/TR]
[TR]
[TD]2,8[/TD]
[TD="align: right"]7861[/TD]
[/TR]
[TR]
[TD]1,9[/TD]
[TD="align: right"]8832[/TD]
[/TR]
[TR]
[TD]2,9[/TD]
[TD="align: right"]8898[/TD]
[/TR]
[TR]
[TD]2,10[/TD]
[TD="align: right"]9587[/TD]
[/TR]
[TR]
[TD]2,3[/TD]
[TD="align: right"]9803
[/TD]
[/TR]
</tbody>[/TABLE]
But, when I try to sort by the IndexID column I get the following:
[TABLE="width: 163"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]IndexID[/TD]
[TD]Part Number[/TD]
[/TR]
[TR]
[TD]1,1[/TD]
[TD="align: right"]3807[/TD]
[/TR]
[TR]
[TD]1,10[/TD]
[TD="align: right"]2627[/TD]
[/TR]
[TR]
[TD]1,11[/TD]
[TD="align: right"]6802[/TD]
[/TR]
[TR]
[TD]1,12[/TD]
[TD="align: right"]4395[/TD]
[/TR]
[TR]
[TD]1,2[/TD]
[TD="align: right"]6680[/TD]
[/TR]
[TR]
[TD]1,3[/TD]
[TD="align: right"]4440[/TD]
[/TR]
[TR]
[TD]1,4[/TD]
[TD="align: right"]2074[/TD]
[/TR]
[TR]
[TD]1,5[/TD]
[TD="align: right"]5021[/TD]
[/TR]
[TR]
[TD]1,6[/TD]
[TD="align: right"]2298[/TD]
[/TR]
[TR]
[TD]1,7[/TD]
[TD="align: right"]1572[/TD]
[/TR]
[TR]
[TD]1,8[/TD]
[TD="align: right"]3379[/TD]
[/TR]
[TR]
[TD]1,9[/TD]
[TD="align: right"]8832[/TD]
[/TR]
[TR]
[TD]2,1[/TD]
[TD="align: right"]7504[/TD]
[/TR]
[TR]
[TD]2,10[/TD]
[TD="align: right"]9587[/TD]
[/TR]
[TR]
[TD]2,11[/TD]
[TD="align: right"]3924[/TD]
[/TR]
[TR]
[TD]2,12[/TD]
[TD="align: right"]6043[/TD]
[/TR]
[TR]
[TD]2,2[/TD]
[TD="align: right"]4109[/TD]
[/TR]
[TR]
[TD]2,3[/TD]
[TD="align: right"]9803[/TD]
[/TR]
[TR]
[TD]2,4[/TD]
[TD="align: right"]5461[/TD]
[/TR]
[TR]
[TD]2,5[/TD]
[TD="align: right"]2052[/TD]
[/TR]
[TR]
[TD]2,6[/TD]
[TD="align: right"]2779[/TD]
[/TR]
[TR]
[TD]2,7[/TD]
[TD="align: right"]3397[/TD]
[/TR]
[TR]
[TD]2,8[/TD]
[TD="align: right"]7861[/TD]
[/TR]
[TR]
[TD]2,9[/TD]
[TD="align: right"]8898
[/TD]
[/TR]
</tbody>[/TABLE]
I need the numbers in the IndexID to be back like it started at the top of my description.
Is there a way to have it sort the columns as if they were numbers rather than strings?
Also, I need a solution that does NOT include adding columns to partially divide up the strings.
If we need a VBA solution, I am open to that as well.
Thanks,
Rich
[TABLE="width: 163"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]IndexID[/TD]
[TD]Part Number[/TD]
[/TR]
[TR]
[TD]1,1[/TD]
[TD="align: right"]3807[/TD]
[/TR]
[TR]
[TD]1,2[/TD]
[TD="align: right"]6680[/TD]
[/TR]
[TR]
[TD]1,3[/TD]
[TD="align: right"]4440[/TD]
[/TR]
[TR]
[TD]1,4[/TD]
[TD="align: right"]2074[/TD]
[/TR]
[TR]
[TD]1,5[/TD]
[TD="align: right"]5021[/TD]
[/TR]
[TR]
[TD]1,6[/TD]
[TD="align: right"]2298[/TD]
[/TR]
[TR]
[TD]1,7[/TD]
[TD="align: right"]1572[/TD]
[/TR]
[TR]
[TD]1,8[/TD]
[TD="align: right"]3379[/TD]
[/TR]
[TR]
[TD]1,9[/TD]
[TD="align: right"]8832[/TD]
[/TR]
[TR]
[TD]1,10[/TD]
[TD="align: right"]2627[/TD]
[/TR]
[TR]
[TD]1,11[/TD]
[TD="align: right"]6802[/TD]
[/TR]
[TR]
[TD]1,12[/TD]
[TD="align: right"]4395[/TD]
[/TR]
[TR]
[TD]2,1[/TD]
[TD="align: right"]7504[/TD]
[/TR]
[TR]
[TD]2,2[/TD]
[TD="align: right"]4109[/TD]
[/TR]
[TR]
[TD]2,3[/TD]
[TD="align: right"]9803[/TD]
[/TR]
[TR]
[TD]2,4[/TD]
[TD="align: right"]5461[/TD]
[/TR]
[TR]
[TD]2,5[/TD]
[TD="align: right"]2052[/TD]
[/TR]
[TR]
[TD]2,6[/TD]
[TD="align: right"]2779[/TD]
[/TR]
[TR]
[TD]2,7[/TD]
[TD="align: right"]3397[/TD]
[/TR]
[TR]
[TD]2,8[/TD]
[TD="align: right"]7861[/TD]
[/TR]
[TR]
[TD]2,9[/TD]
[TD="align: right"]8898[/TD]
[/TR]
[TR]
[TD]2,10[/TD]
[TD="align: right"]9587[/TD]
[/TR]
[TR]
[TD]2,11[/TD]
[TD="align: right"]3924[/TD]
[/TR]
[TR]
[TD]2,12[/TD]
[TD="align: right"]6043[/TD]
[/TR]
</tbody>[/TABLE]
When I sort by Part number, I get the following:
[TABLE="width: 163"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]IndexID[/TD]
[TD]Part Number[/TD]
[/TR]
[TR]
[TD]1,7[/TD]
[TD="align: right"]1572[/TD]
[/TR]
[TR]
[TD]2,5[/TD]
[TD="align: right"]2052[/TD]
[/TR]
[TR]
[TD]1,4[/TD]
[TD="align: right"]2074[/TD]
[/TR]
[TR]
[TD]1,6[/TD]
[TD="align: right"]2298[/TD]
[/TR]
[TR]
[TD]1,10[/TD]
[TD="align: right"]2627[/TD]
[/TR]
[TR]
[TD]2,6[/TD]
[TD="align: right"]2779[/TD]
[/TR]
[TR]
[TD]1,8[/TD]
[TD="align: right"]3379[/TD]
[/TR]
[TR]
[TD]2,7[/TD]
[TD="align: right"]3397[/TD]
[/TR]
[TR]
[TD]1,1[/TD]
[TD="align: right"]3807[/TD]
[/TR]
[TR]
[TD]2,11[/TD]
[TD="align: right"]3924[/TD]
[/TR]
[TR]
[TD]2,2[/TD]
[TD="align: right"]4109[/TD]
[/TR]
[TR]
[TD]1,12[/TD]
[TD="align: right"]4395[/TD]
[/TR]
[TR]
[TD]1,3[/TD]
[TD="align: right"]4440[/TD]
[/TR]
[TR]
[TD]1,5[/TD]
[TD="align: right"]5021[/TD]
[/TR]
[TR]
[TD]2,4[/TD]
[TD="align: right"]5461[/TD]
[/TR]
[TR]
[TD]2,12[/TD]
[TD="align: right"]6043[/TD]
[/TR]
[TR]
[TD]1,2[/TD]
[TD="align: right"]6680[/TD]
[/TR]
[TR]
[TD]1,11[/TD]
[TD="align: right"]6802[/TD]
[/TR]
[TR]
[TD]2,1[/TD]
[TD="align: right"]7504[/TD]
[/TR]
[TR]
[TD]2,8[/TD]
[TD="align: right"]7861[/TD]
[/TR]
[TR]
[TD]1,9[/TD]
[TD="align: right"]8832[/TD]
[/TR]
[TR]
[TD]2,9[/TD]
[TD="align: right"]8898[/TD]
[/TR]
[TR]
[TD]2,10[/TD]
[TD="align: right"]9587[/TD]
[/TR]
[TR]
[TD]2,3[/TD]
[TD="align: right"]9803
[/TD]
[/TR]
</tbody>[/TABLE]
But, when I try to sort by the IndexID column I get the following:
[TABLE="width: 163"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]IndexID[/TD]
[TD]Part Number[/TD]
[/TR]
[TR]
[TD]1,1[/TD]
[TD="align: right"]3807[/TD]
[/TR]
[TR]
[TD]1,10[/TD]
[TD="align: right"]2627[/TD]
[/TR]
[TR]
[TD]1,11[/TD]
[TD="align: right"]6802[/TD]
[/TR]
[TR]
[TD]1,12[/TD]
[TD="align: right"]4395[/TD]
[/TR]
[TR]
[TD]1,2[/TD]
[TD="align: right"]6680[/TD]
[/TR]
[TR]
[TD]1,3[/TD]
[TD="align: right"]4440[/TD]
[/TR]
[TR]
[TD]1,4[/TD]
[TD="align: right"]2074[/TD]
[/TR]
[TR]
[TD]1,5[/TD]
[TD="align: right"]5021[/TD]
[/TR]
[TR]
[TD]1,6[/TD]
[TD="align: right"]2298[/TD]
[/TR]
[TR]
[TD]1,7[/TD]
[TD="align: right"]1572[/TD]
[/TR]
[TR]
[TD]1,8[/TD]
[TD="align: right"]3379[/TD]
[/TR]
[TR]
[TD]1,9[/TD]
[TD="align: right"]8832[/TD]
[/TR]
[TR]
[TD]2,1[/TD]
[TD="align: right"]7504[/TD]
[/TR]
[TR]
[TD]2,10[/TD]
[TD="align: right"]9587[/TD]
[/TR]
[TR]
[TD]2,11[/TD]
[TD="align: right"]3924[/TD]
[/TR]
[TR]
[TD]2,12[/TD]
[TD="align: right"]6043[/TD]
[/TR]
[TR]
[TD]2,2[/TD]
[TD="align: right"]4109[/TD]
[/TR]
[TR]
[TD]2,3[/TD]
[TD="align: right"]9803[/TD]
[/TR]
[TR]
[TD]2,4[/TD]
[TD="align: right"]5461[/TD]
[/TR]
[TR]
[TD]2,5[/TD]
[TD="align: right"]2052[/TD]
[/TR]
[TR]
[TD]2,6[/TD]
[TD="align: right"]2779[/TD]
[/TR]
[TR]
[TD]2,7[/TD]
[TD="align: right"]3397[/TD]
[/TR]
[TR]
[TD]2,8[/TD]
[TD="align: right"]7861[/TD]
[/TR]
[TR]
[TD]2,9[/TD]
[TD="align: right"]8898
[/TD]
[/TR]
</tbody>[/TABLE]
I need the numbers in the IndexID to be back like it started at the top of my description.
Is there a way to have it sort the columns as if they were numbers rather than strings?
Also, I need a solution that does NOT include adding columns to partially divide up the strings.
If we need a VBA solution, I am open to that as well.
Thanks,
Rich