How to use cell variables in filter function

Question

Being pretty new to google sheets I hope to find a way to use a cell as a variable without having to code custom functions for it.

For example how do I use this function:

so that I can declare a cell as a variable and use it in the function?

Attempts:

JPV · Accepted Answer · 2020-03-06 08:35:20Z

1

Try

=filter(indirect(E8); not(isblank(indirect(E9))))

or

=filter(indirect(E8); len(indirect(E9)))

answered Mar 6, 2020 at 8:35

JPV

27.4k4 gold badges37 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1