Dear community members, today I have the following question. Let's assume a list like the following:
LIST(1 , 2 , 5 , 7 , 9 , 13 , 15)
I want to find the location of the elements in the list. For the case I describe it would be:
1 = 1
2 = 2
5 = 3
7 = 4
9 = 5
13 = 6
15 = 7
With FIND() I could improvise something from 1 to 9 but after 9 it gets complicated since it analyzes exact matches and, unfortunately, does not consider separators.
Have any of you ever needed something like me? If so, would you be so kind as to explain to me how to proceed?
LinkedIn
Twitter
