Forum Discussion
Issue with FILTER function not displaying all results
So I am using the filter function to summarize information from a different sheet. I have entered the following =FILTER(Transactions!$H$3:$J$9995, Transactions!$G$3:$G$9995=O2,"") On the Transaction...
The first step in debugging might be to test the array relationship
=Transactions!$G$3:$G$9995=O2
or using a defined Name
= Category="Utilities"
Only if that works, is it worth going on to consider the formula
= FILTER(Date, Category="Utilities")
=Transactions!$G$3:$G$9995=O2
or using a defined Name
= Category="Utilities"
Only if that works, is it worth going on to consider the formula
= FILTER(Date, Category="Utilities")