Hello
Is there a formula that will return positions of matches in an array?
E.g. searching for "a" in {"a","b","a","c"} should return {1,0,3,0} or something like that?
I would then need to find the position that is e.g. ">2" and return that position to feed it into INDEX.
Thanks!
Is there a formula that will return positions of matches in an array?
E.g. searching for "a" in {"a","b","a","c"} should return {1,0,3,0} or something like that?
I would then need to find the position that is e.g. ">2" and return that position to feed it into INDEX.
Thanks!