Edit - Super User

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Rev

Thank you, @Jim K. I confirmed that works for the case of Node 4, getting 3 items ordered ascending, but if I replace the value of 4 with 3, I only get 1 result (3), when I am looking for 3 results again (should always be 3 for this geometric configuration), namely a match on "C" from columns D17:E22, which should give me 2,3 and 6. Is there a way to specify that?
– Eric Marceau
Commented Oct 31, 2023 at 20:53
Is it possible to have the arrays limit themselves to the size of the results, not the size of the "source" lookup "array"?
– Eric Marceau
Commented Oct 31, 2023 at 21:43
Is there a way to use OR to combine the results of two separate formulas in the same formula, each focusing on one of the columns "D" or "E" ? If I use a separate formula for 2 separate "arrays" (columns), is there a way to OR those two "arrays" into a single new array which has no empty cells?
– Eric Marceau
Commented Oct 31, 2023 at 21:45
@EricMarceau: See edited answer to handle that example.
– Jim K
Commented Oct 31, 2023 at 21:50
Thank you again, @Jim K. Is there any way to "output" nothing, i.e. not "add" empty string as a case response in an array position, thereby leaving only "real" responses in the array, which would then be limited to the size of actual data?
– Eric Marceau
Commented Nov 1, 2023 at 2:23

| Show 2 more comments

Correct minor typos or mistakes
Clarify meaning without changing it
Add related resources or links
Always respect the author’s intent
Don’t use edits to reply to the author

create code fences with backticks ` or tildes ~
```
like so
```
add language identifier to highlight code
```python
def function(foo):
print(foo)
```
put returns between paragraphs
for linebreak add 2 spaces at end
_italic_ or **bold**
indent code by 4 spaces
backtick escapes `like _so_`
quote by placing > at start of line
to make links (use https whenever possible)
<https://example.com>
[example](https://example.com)
<a href="https://example.com">example</a>

formatting help »
answering help »