The VECTOR RANK function returns a new vector that specifies the rank of the elements in vec. If direction is greater than 0 the entries are ranked from smallest to biggest, otherwise from biggest to smallest. The first ranked element has a rank of 1, the second of 2 and so on. If two elements are the same the will arbitrarily be assigned contiguous ranks. Do NOT use the result of this function with VECTOR REORDER as this will return meaningless results.
company : (c1-c5)
revenue[company] = 5000,3000,8000
revenue rank[company] = VECTOR RANK(revenue[company],1)
Will return 2,1,3 for revenue rank.
Units: VECTOR RANK(units,dmnl) --> dmnl
Restrictions: Must appear first on the right and can’t be followed by anything else. Ranking is done on the complete vector relative to the last subscript. Subranges will not work.
Availability: Professional and DSS only.