/

IndexNonBlankStringArray

[this page | pdf]

Function Description

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


Output type / Parameter details

Output type: Integer()
Parameter NameVariable TypeDescription
ArrayToBeIndexedString()Array we want to index
IndexString()Array of index in which we will look for different (non-blank) entries

Links to:

-          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


Desktop view | Switch to Mobile