This content is likely not relevant anymore. Try searching or browse recent questions.
How to reference Arrayformula result as array, not value 1 Recommended Answer 7 Replies 2 Upvotes
I'm trying to reference the result of a FILTER expression as an array, but instead of giving me the array, it just gives me the first value of the filter. In the following sheet,
https://docs.google.com/spreadsheets/d/1ai4KGItxjqfboWQ3qxSZjs9je5beryqvRRYZnTa-U4I/edit#gid=107293152
I attempt define the arrayformula in cell C19 using the array result from D19:
C19 = ARRAYFORMULA(...D19...)
D19 = FILTER(...)
where I want C19 to use the actual list returned by FILTER in D19. Only one value, however, is returned. If, instead of referencing "D19" in the formula of C19, I just copy and paste the formula for D19 there directly, the arrayformula works as expected. But I'd rather not do that since I want to be able edit D19 without having to make the same edit in C19 as well (it also seems inefficient). Replacing "D19" with "D19:D40" also works, but the length of the D19 array is expected to change over time, and I don't want to have to manually adjust the range of D19:D40 every time that it changes. So my question is this: is there any way to reference the array result of an arrayformula (or filter, or anything that returns an arrayformula-like result) from another cell?
Any suggestions or alternative ideas are appreciated.
Thanks!
Details
Link to post
Delete post?
This will remove the reply from the Answers section.
Notifications are off
Your notifications are currently off and you won't receive subscription updates. To turn them on, go to Notifications preferences on your Profile page.