New expression: INDEXOF()

INDEXOF(item,list) : Returns the index value of item in list.

Example:

INDEXOF( “g” , LIST( “t” , “h” , “g” ) )

returns 3

Agreed, we could really use this function. I’m out of votes though. :man_facepalming:

What if the value occurs in the list more than once?

Return the LIST of positions, or the first occurrence’s position?

I’d also like to see an optional 3rd parameter for starting position.

This way you wouldn’t have to SPLIT() the list first if you want to search from somewhere in the middle.

3 Likes

Limited to Votes,
But Im voting on this in my Heart.

1 Like