IndexNonBlankStringArray

[this page | pdf]

Returns an (integer) array containing the location (base 0) indicating where in the Index array each entry in the ArrayToBeIndexed appears.

Elements of the Index array must be unique. If the entry in the ArrayToBeIndexed is blank then the corresponding entry in the output array is -2. If it does not appear in the Index array then the corresponding entry in the output array is -1. If it does appear then will be some value 0 to  where there are  entries in the Index array.

There is no need for either the Index array or the ArrayToBeIndexed to be pre-sorted.

NAVIGATION LINKS
Contents | Prev | Next

-          Interactively run function

-          Interactive instructions

-          Example calculation

-          Output type / Parameter details

-          Illustrative spreadsheet

-          Other General functions

-          Computation units used

Note: If you use any Nematrian web service either programmatically or interactively then you will be deemed to have agreed to the Nematrian website License Agreement