INDEXOF
Syntax
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 |