FILTER function #VALUE! error

Question

Hello - I want to use the FILTER function to enter row data into a new sheet. I am trying out the basic FILTER function formula first and getting a #VALUE! error. Not sure where I'm going wrong. Thank you.

Answer 1

I think you want

=FILTER(A4:C12, C4:C12=G1, "")

Answer 2

Hello,

Thanks for the earlier help. I notice I can't use filter function with tables. Is there a way to use the FILTER function to populate a table? I can set up my table values to =FILTER function output, but that is not very elegant solution.

Cheers,

N. Ruehlen

Answer 3

You can refer to a table in a FILTER formula, but you cannot enter a FILTER formula in a table. This is because FILTER returns a dynamic number of rows, Tables cannot handle that.

Answer 4

Thank you,

I ended up setting up the Filter function to output into a range of cells then to populate my table set the table cell values to = the Filter function output cell values, then hide the Filter function output columns and set print area to my table.

Cheers,

-Nevada