Sort, list, F StringSort ;Sort function
;Sort Function Output: Excel Sort Order:
; 1-Series 124 Spider
; 124 Spider 190
; 2 1-Series
; 190 2
; 2-Series 260
; 3 2-Series
; 260 3
; 360 360
; 4-Series 4-Series
; 5 5
; 500 500
;Sort function I used found in AHK documentation
return a1 > a2 ? 1 : a1 < a2 ? -1 : 0 ; Sorts alphabetically based on the setting of StringCaseSense.
As you can see the sort order does not match how Excel sorts. The sort order in my script needs to be identical to Excel's sort method so when the list is inserted into an Array, the index value of each row should match with Excel so I can accurately call each value by using its index.
Any ideas on how to solve this? Perhaps someone has a sort function that already does this? Thanks!