Forum Discussion
#Name? error in my filter formula.
Hi, looking for help solving my formula issue. What I'm looking for my formula to do. Input all the rows that have the word "needed" in them into a new workbook. To do So I have been trying the fi...
I don't understand. The range in the 2nd argument of the FILTER function should be a single column.
And if you want to refer to a range in another workbook, it has to be in the form
'[workbook name]sheet name'!range