I'm trying to return every instance of a value within a data range. Is this possible without an array formula?
In the attached examples you'll see the first one returns two instances, the second example returns one instance.
I hope that's enough information to go on.
Bookmarks