Sep 21 2022 12:11 PM
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 Transactions sheet in columns H-J I have Date, Source and Amount. In column G I have Category. I am trying to display the Date, Source and Amount for transactions that are categorized as "Utilities" In cell O2, I have "Utilities". For some reason, the filter function is not displaying all of the data that has been categorized as "Utilities". I am unsure what I have done wrong as I have double and triple checked that everything is spelled correctly and that all data is within the array.
Sep 21 2022 01:02 PM
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?
Sep 21 2022 01:27 PM - edited Sep 21 2022 01:28 PM
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.
Sep 21 2022 01:48 PM
Dec 20 2023 10:50 AM