How to use _Excel_RangeSort to sort my excel file by three different headers Column A1, B1, and C1 have headers on which I want to sort by. The headers on which I want to sort are department, employee type, and name.
I still really new to AutoIt so I do not actually know how to properly start this line or lines of code, to be honest. The example code is the best I can do.
_Excel_RangeSort($OpenWorkbook, Default, "A1:C1", "1:1", $xlDescending, Default, $xlYes, Default, $xlSortRows) I just need to sort by those three headers in that order of department, employee type, and name, plus in descending order.
 
any and all help would be greatly appreciated.  Thank you!

Hi and Hello from a Noob..:-)
i have a very weird problem. I fill up a 2d array with a)numbers and b)letters from A-Z, so 2 columns. This works absolutely perfect. But as soon as i try to sort them (numbers ascending) the array ends up in some kind of "String-sortation". What exactly am i doin wrong? To make it easy, i post below the piece of code, which i am talking about. Hope that someone can help me out.
Func Analyse()
    Local $BasisArray[0]
    Local $aFill = "A" & "|B" & "|C" & "|D" & "|E" & "|F" & "|G" & "|H" & "|I" & "|J" & "|K" & "|L" & "|M" & "|N" & "|O" & "|P" & "|Q" & "|R" & "|S" & "|T" & "|U" & "|V" & "|W" & "|X" & "|Y" & "|Z"
    _ArrayAdd ($BasisArray, $afill)
    Local $FreqArray[0][2]=[[]]
 
    $row = 0

    For $i = 0 to 25
 
        $fummel = _ArrayToString ($BasisArray, ":" , $row, $row)
        $readout = _GUICtrlRichEdit_GetText ($hRichEdit)
        $anzAs = stringreplace ($readout, $fummel, $fummel)
        $extended = @extended
        $FreqFill = $extended & "|" & $fummel
        _ArrayAdd($FreqArray, $FreqFill)
 
        $row = $row + 1
    Next
    _ArrayDisplay($FreqArray, "2D - Item delimited")
    _ArraySort($FreqArray)
    _ArrayDisplay($FreqArray, "bla")
 
 
Thanks for helping me,
 
Cheers,
 
Patrick

Hello everyone,
How can I display in ascending  sequence some numbers stored in a string variable?
$str = "18,03,48,23" MsgBox(0,"test",$str) I would like it to display "03,18,23,48"

So I've made this script that detects how long i have held down my left mouse button for and stores the information in an array and then sorts its using _ArraySort but the output is half sorted half broken.
Here's my script:
HotKeySet("{F1}","_exit") #include <Misc.au3> #include <Timers.au3> #include <Array.au3> Local $dll = DllOpen("user32.dll") $on = False Global $array[0] While(1) If _IsPressed(01,$dll) Then $timer = _Timer_Init() While _IsPressed(01,$dll) Sleep(1) WEnd $time = _Timer_Diff($timer) _ArrayAdd($array,"Time: " & Floor($time) & " ms") ;~ ConsoleWrite("Time: " & Floor($time) & " ms" & @CRLF) EndIf Sleep(50) WEnd Func _exit() _ArraySort($array) _ArrayDisplay($array) Exit EndFunc And the output:

See how its not sorted?  What is the problem here?

Hi, i'm just curious is there a way to sort an ini file after largest first?
my inifiles writes itself like this
14=500
13=GREY
12=500
11=600
10=600
9=600
8=700
7=700
5=600
3=600
2=800
1=700
15=GREY
4=GREY
 
but is there a way so i can get it sortet 
15
14
13
12 
etc?