Sort fault with values over 10002019 Community Moderator ElectionHow do I sort a list of dictionaries by a value of the dictionary?Sort a Map<Key, Value> by valuesHow do I sort a dictionary by value?How do I sort an NSMutableArray with custom objects in it?Sorting an array of JavaScript objectsSort array of objects by string property valueHow to sort a dataframe by multiple column(s)?How to Sort Multi-dimensional Array by Value?Sort ArrayList of custom Objects by propertyHow to Sort a List<T> by a property in the object
How could our ancestors have domesticated a solitary predator?
How did Alan Turing break the enigma code using the hint given by the lady in the bar?
show this identity with trigometric
Placing subfig vertically
Word for a person who has no opinion about whether god exists
"One can do his homework in the library"
Single word request: Harming the benefactor
Should QA ask requirements to developers?
Algorithm to convert a fixed-length string to the smallest possible collision-free representation?
Offered promotion but I'm leaving. Should I tell?
PTIJ: How can I halachically kill a vampire?
If the Captain's screens are out, does he switch seats with the co-pilot?
They call me Inspector Morse
Fourth person (in Slavey language)
What are the best books to study Neural Networks from a purely mathematical perspective?
Rejected in 4th interview round citing insufficient years of experience
My story is written in English, but is set in my home country. What language should I use for the dialogue?
Why the color red for the Republican Party
MTG: Can I kill an opponent in response to lethal activated abilities, and not take the damage?
What do you call the air that rushes into your car in the highway?
Am I not good enough for you?
Is having access to past exams cheating and, if yes, could it be proven just by a good grade?
How do I deal with a powergamer in a game full of beginners in a school club?
infinitive telling the purpose
Sort fault with values over 1000
2019 Community Moderator ElectionHow do I sort a list of dictionaries by a value of the dictionary?Sort a Map<Key, Value> by valuesHow do I sort a dictionary by value?How do I sort an NSMutableArray with custom objects in it?Sorting an array of JavaScript objectsSort array of objects by string property valueHow to sort a dataframe by multiple column(s)?How to Sort Multi-dimensional Array by Value?Sort ArrayList of custom Objects by propertyHow to Sort a List<T> by a property in the object
I have a problem sorting rows From lowest value to highest value
Current list of sorted items (column D):
DBB1172
DBB1178
DBB1184
DBB1196
DBB1202
DBB1208
DBB332
DBB338
DBB344
DBB350
DBB356
What it should be:
DBB332
DBB338
DBB344
DBB350
DBB356
DBB1172
DBB1178
DBB1184
DBB1196
DBB1202
DBB1208
My code:
LastUsedRow = ThisWorkbook.Sheets("Valve").Range("C4").End(xlDown).row
lastusedcolomb = ThisWorkbook.Sheets("Valve").Range("C4").End(xlToRight).Column
NumberOfItems = LastUsedRow - 3
Debug.Print NumberOfItems
ThisWorkbook.Sheets("Valve").Range("C4:S" & LastUsedRow).Sort key1:=Sheets("Valve").Range("D:D"), Order1:=xlAscending, Header:=xlNo, _
orderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal
excel vba sorting
edited Mar 7 at 8:25
Pᴇʜ
23.8k62952
asked Mar 7 at 7:48
Tobi HuybrechtsTobi Huybrechts
11
add a comment |
I have a problem sorting rows From lowest value to highest value
Current list of sorted items (column D):
DBB1172
DBB1178
DBB1184
DBB1196
DBB1202
DBB1208
DBB332
DBB338
DBB344
DBB350
DBB356
What it should be:
DBB332
DBB338
DBB344
DBB350
DBB356
DBB1172
DBB1178
DBB1184
DBB1196
DBB1202
DBB1208
My code:
LastUsedRow = ThisWorkbook.Sheets("Valve").Range("C4").End(xlDown).row
lastusedcolomb = ThisWorkbook.Sheets("Valve").Range("C4").End(xlToRight).Column
NumberOfItems = LastUsedRow - 3
Debug.Print NumberOfItems
ThisWorkbook.Sheets("Valve").Range("C4:S" & LastUsedRow).Sort key1:=Sheets("Valve").Range("D:D"), Order1:=xlAscending, Header:=xlNo, _
orderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal
excel vba sorting
edited Mar 7 at 8:25
Pᴇʜ
23.8k62952
asked Mar 7 at 7:48
Tobi HuybrechtsTobi Huybrechts
11
2
you are sorting strings, not numbers
– patel
Mar 7 at 7:58
You can pad the numeric portion with leading zero's before sorting; or split into two columns and sort numeric and alpha portions separately.
– Ron Rosenfeld
Mar 7 at 12:10
add a comment |
I have a problem sorting rows From lowest value to highest value
Current list of sorted items (column D):
DBB1172
DBB1178
DBB1184
DBB1196
DBB1202
DBB1208
DBB332
DBB338
DBB344
DBB350
DBB356
What it should be:
DBB332
DBB338
DBB344
DBB350
DBB356
DBB1172
DBB1178
DBB1184
DBB1196
DBB1202
DBB1208
My code:
LastUsedRow = ThisWorkbook.Sheets("Valve").Range("C4").End(xlDown).row
lastusedcolomb = ThisWorkbook.Sheets("Valve").Range("C4").End(xlToRight).Column
NumberOfItems = LastUsedRow - 3
Debug.Print NumberOfItems
ThisWorkbook.Sheets("Valve").Range("C4:S" & LastUsedRow).Sort key1:=Sheets("Valve").Range("D:D"), Order1:=xlAscending, Header:=xlNo, _
orderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal
excel vba sorting
edited Mar 7 at 8:25
Pᴇʜ
23.8k62952
asked Mar 7 at 7:48
Tobi HuybrechtsTobi Huybrechts
11
I have a problem sorting rows From lowest value to highest value
Current list of sorted items (column D):
DBB1172
DBB1178
DBB1184
DBB1196
DBB1202
DBB1208
DBB332
DBB338
DBB344
DBB350
DBB356
What it should be:
DBB332
DBB338
DBB344
DBB350
DBB356
DBB1172
DBB1178
DBB1184
DBB1196
DBB1202
DBB1208
My code:
LastUsedRow = ThisWorkbook.Sheets("Valve").Range("C4").End(xlDown).row
lastusedcolomb = ThisWorkbook.Sheets("Valve").Range("C4").End(xlToRight).Column
NumberOfItems = LastUsedRow - 3
Debug.Print NumberOfItems
ThisWorkbook.Sheets("Valve").Range("C4:S" & LastUsedRow).Sort key1:=Sheets("Valve").Range("D:D"), Order1:=xlAscending, Header:=xlNo, _
orderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal
excel vba sorting
excel vba sorting
edited Mar 7 at 8:25
Pᴇʜ
23.8k62952
asked Mar 7 at 7:48
Tobi HuybrechtsTobi Huybrechts
11
edited Mar 7 at 8:25
Pᴇʜ
23.8k62952
asked Mar 7 at 7:48
Tobi HuybrechtsTobi Huybrechts
11
edited Mar 7 at 8:25
Pᴇʜ
23.8k62952
edited Mar 7 at 8:25
Pᴇʜ
23.8k62952
edited Mar 7 at 8:25
Pᴇʜ
23.8k62952
23.8k62952
asked Mar 7 at 7:48
Tobi HuybrechtsTobi Huybrechts
11
asked Mar 7 at 7:48
Tobi HuybrechtsTobi Huybrechts
11
asked Mar 7 at 7:48
Tobi HuybrechtsTobi Huybrechts
11
11
2
you are sorting strings, not numbers
– patel
Mar 7 at 7:58
You can pad the numeric portion with leading zero's before sorting; or split into two columns and sort numeric and alpha portions separately.
– Ron Rosenfeld
Mar 7 at 12:10
add a comment |
2
you are sorting strings, not numbers
– patel
Mar 7 at 7:58
You can pad the numeric portion with leading zero's before sorting; or split into two columns and sort numeric and alpha portions separately.
– Ron Rosenfeld
Mar 7 at 12:10
2
2
you are sorting strings, not numbers
– patel
Mar 7 at 7:58
you are sorting strings, not numbers
– patel
Mar 7 at 7:58
You can pad the numeric portion with leading zero's before sorting; or split into two columns and sort numeric and alpha portions separately.
– Ron Rosenfeld
Mar 7 at 12:10
You can pad the numeric portion with leading zero's before sorting; or split into two columns and sort numeric and alpha portions separately.
– Ron Rosenfeld
Mar 7 at 12:10
add a comment |
1 Answer
1
active
oldest
votes
If a helper column is fine then supposing your data is in column A.
In the helper column, put formula, say cell B2:
=MID(A2,4,99)+0
Copy down and then while sorting, sort on column B (Ascending).
answered Mar 7 at 8:33
shrivallabha.redijshrivallabha.redij
2,5221418
1
The only way to sort this without a helper column is to write a new sort algorithm. None of the built in Excel sort algorithms can do such a sort.
– Pᴇʜ
Mar 7 at 8:35
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55038574%2fsort-fault-with-values-over-1000%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
If a helper column is fine then supposing your data is in column A.
In the helper column, put formula, say cell B2:
=MID(A2,4,99)+0
Copy down and then while sorting, sort on column B (Ascending).
answered Mar 7 at 8:33
shrivallabha.redijshrivallabha.redij
2,5221418
1
The only way to sort this without a helper column is to write a new sort algorithm. None of the built in Excel sort algorithms can do such a sort.
– Pᴇʜ
Mar 7 at 8:35
add a comment |
If a helper column is fine then supposing your data is in column A.
In the helper column, put formula, say cell B2:
=MID(A2,4,99)+0
Copy down and then while sorting, sort on column B (Ascending).
answered Mar 7 at 8:33
shrivallabha.redijshrivallabha.redij
2,5221418
1
The only way to sort this without a helper column is to write a new sort algorithm. None of the built in Excel sort algorithms can do such a sort.
– Pᴇʜ
Mar 7 at 8:35
add a comment |
If a helper column is fine then supposing your data is in column A.
In the helper column, put formula, say cell B2:
=MID(A2,4,99)+0
Copy down and then while sorting, sort on column B (Ascending).
answered Mar 7 at 8:33
shrivallabha.redijshrivallabha.redij
2,5221418
If a helper column is fine then supposing your data is in column A.
In the helper column, put formula, say cell B2:
=MID(A2,4,99)+0
Copy down and then while sorting, sort on column B (Ascending).
answered Mar 7 at 8:33
shrivallabha.redijshrivallabha.redij
2,5221418
answered Mar 7 at 8:33
shrivallabha.redijshrivallabha.redij
2,5221418
answered Mar 7 at 8:33
shrivallabha.redijshrivallabha.redij
2,5221418
answered Mar 7 at 8:33
shrivallabha.redijshrivallabha.redij
2,5221418
2,5221418
1
The only way to sort this without a helper column is to write a new sort algorithm. None of the built in Excel sort algorithms can do such a sort.
– Pᴇʜ
Mar 7 at 8:35
add a comment |
1
The only way to sort this without a helper column is to write a new sort algorithm. None of the built in Excel sort algorithms can do such a sort.
– Pᴇʜ
Mar 7 at 8:35
1
1
The only way to sort this without a helper column is to write a new sort algorithm. None of the built in Excel sort algorithms can do such a sort.
– Pᴇʜ
Mar 7 at 8:35
The only way to sort this without a helper column is to write a new sort algorithm. None of the built in Excel sort algorithms can do such a sort.
– Pᴇʜ
Mar 7 at 8:35
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55038574%2fsort-fault-with-values-over-1000%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
you are sorting strings, not numbers
– patel
Mar 7 at 7:58
You can pad the numeric portion with leading zero's before sorting; or split into two columns and sort numeric and alpha portions separately.
– Ron Rosenfeld
Mar 7 at 12:10