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...
Maybe the reason is "Utilities " with a space in the end like in cell G10 in the example. Because of this the row is not included in the filtered range. Otherwise can you attach your file or screenshots without sensitive data?
I checked that all category cells were the same. I even copied and pasted the cell with "Utilities" to make sure they were all the same but some of the rows are still not displaying with the filter. I am busy for the next few hours but will upload screenshots later.