Originally Posted By: Pax

edit: oooo just found qsort() and uniq(). I will explore tomorrow.


How does one reference an array read in by ReadExcel2()? If I read in the excel spreadsheet with 2 columns, the first with office, and the second with brand using
 Code:
$Brandshop = readexcel2(@Scriptdir + '\pccs.xlsx',,-1,-1)

Ideally I could use nexted functions so that
 Code:
$validbrands = uniq(qsort($Brandshop[??,1],1))

I thought that possibly $brandshop[0,1] might reference they array iself, but when I printed the array - qsort($Brandshop[??,1],1) - to screen using the code
 Code:
$sortedbrands = qsort($Brandshop[0,1],1)
    For $i = 0 to UBound($sortedbrands)
       ? $sortedbrands[$i] + ','
    Next
I just get '-1' as the response.

Am I missing something obvious here?

Pax