Syntax
INDEXOF(<list>;<element any>)
Description
Returns (as an integer) the index of the first occurence of an element in a list counting from zero (0) or -1 if the element isn't found.
Examples
| Column1 | Searching for element | INDEXOF returns |
|---|---|---|
| [1, 2, 3, 4, 5] | 4 | 3 |
| [apple, banana, peach, orange, kiwi] | peach | 2 |
| [11, 12, 13, 14, 15] | 17 | -1 |
...