Hi All,
To get unique value from column i use below code but it si not working. can you tell me where i am wrong pls?
Local $oExcel = _Excel_Open()
Local $oWorkbook = _Excel_BookOpen($oExcel, @ScriptDir & "\test.xlsx")
$bat = _Excel_RangeRead($oWorkbook,1,"AY3:AY7")
_ArrayDisplay($bat)
$d = _ArrayUnique($bat)
_ArrayDisplay($d)
thanks,