Comments on: Easy Google Sheets FILTER Function Guide for 2024 https://spreadsheetpoint.com/formulas/filter-function-google-sheets/ Google Sheets Tips & Tutorials Fri, 02 Feb 2024 13:06:47 +0000 hourly 1 https://wordpress.org/?v=6.7.1 By: jmarkus https://spreadsheetpoint.com/formulas/filter-function-google-sheets/#comment-13491 Fri, 02 Feb 2024 13:06:47 +0000 https://spreadsheetpoint.com/?p=1525#comment-13491 In reply to Monirath.

Hey Monirath! Please verify that your FILTER range covers the entire dataset, including potential new rows, and check for consistent data types and formats. If your formula uses absolute row references, adjust them to accommodate potential data expansions. Clear existing filters, as they can interfere with new data display.

]]> By: Monirath https://spreadsheetpoint.com/formulas/filter-function-google-sheets/#comment-8180 Fri, 21 Jan 2022 19:26:41 +0000 https://spreadsheetpoint.com/?p=1525#comment-8180 Hi. First of all, thanks for this tutorial. I have a question. I used this filter function in one of my Google Sheets file and at one point, the function stops working. It does not update new rows with data. I checked and I have the row number as infinite. So no row limit. Have you ever come across this issue? How to deal with it?

]]> By: Alexander https://spreadsheetpoint.com/formulas/filter-function-google-sheets/#comment-7885 Tue, 28 Dec 2021 12:31:52 +0000 https://spreadsheetpoint.com/?p=1525#comment-7885 Thanks for the explanation!
Is it possible to edit the filtered results and have it change the original cells value?
So if I filter everybody from Iowa, but Kathy is actually from New York, can I change that in the filtered results or do I have to find her in the original data?

]]> By: lee https://spreadsheetpoint.com/formulas/filter-function-google-sheets/#comment-7879 Tue, 28 Dec 2021 04:22:22 +0000 https://spreadsheetpoint.com/?p=1525#comment-7879 great tips . Thank you.

]]> By: Ramon https://spreadsheetpoint.com/formulas/filter-function-google-sheets/#comment-6765 Mon, 18 Oct 2021 10:24:22 +0000 https://spreadsheetpoint.com/?p=1525#comment-6765 Hello,
Very clear and a very useful function.
I have tried to use it to obtain data (a range) from another sheet that is in another workbook, but surely I am doing something wrong putting the syntax of the range (url and range). I have even tried using “importrange” inside the filter function, but I have not managed to bring the data and filter it (if it comes from another sheet that is in another book).

]]> By: ron https://spreadsheetpoint.com/formulas/filter-function-google-sheets/#comment-6465 Wed, 29 Sep 2021 03:23:00 +0000 https://spreadsheetpoint.com/?p=1525#comment-6465 Nice work. Great examples.

]]> By: john https://spreadsheetpoint.com/formulas/filter-function-google-sheets/#comment-5089 Wed, 02 Jun 2021 00:32:54 +0000 https://spreadsheetpoint.com/?p=1525#comment-5089 wonderfully clear
thanks!

]]> By: Adam Steinfurth https://spreadsheetpoint.com/formulas/filter-function-google-sheets/#comment-1172 Sat, 12 Sep 2020 11:40:20 +0000 https://spreadsheetpoint.com/?p=1525#comment-1172 Hey there. How about using SORTN to return the top X or bottom X values? Seems easier.

]]>