Table of Contents
To filter cells in Google Sheets and display only those that do not contain specific text, follow these steps:
1. Select the cells that you want to filter.
2. Click on the “Data” tab in the menu bar.
3. Click on “Filter” from the drop-down menu.
4. A small arrow will appear on the top right corner of the selected cells. Click on it.
5. In the drop-down menu, click on “Filter by condition”.
6. A new window will appear. Under “Filter by condition”, select “Does not contain”.
7. In the text box next to it, enter the specific text that you want to exclude.
8. Click on “Ok” to apply the filter.
9. The cells will now be filtered, and only those that do not contain the specific text will be displayed.
This feature is useful when you want to quickly identify and exclude certain data from your spreadsheet.
Google Sheets: Filter for Cells that Do Not Contain Text
You can use the following syntax to filter for cells that do not contain certain text in Google Sheets:
=FILTER(A1:C17, REGEXMATCH(A1:A17, "East")=FALSE)
This formula filters the cells in the range A1:C17 to only return the rows where cells in the range A1:A17 do not contain the word “East”.
You can also use the following syntax to filter for cells that do not contain one of several values in Google Sheets:
=FILTER(A1:C17, REGEXMATCH(A1:A17, "East|West")=FALSE)
This formula filters the cells in the range A1:C17 to only return the rows where cells in the range A1:A17 do not contain the word “East” or West”.
The following examples show how to use this syntax in practice.
Example 1: Filter for Cells that Do Not Contain Text
Suppose we have the following data in Google Sheets:
We can use the following formula to filter for rows where the Region does not contain “East”:
=FILTER(A1:C17, REGEXMATCH(A1:A17, "East")=FALSE)
The following screenshot shows how to use this formula in practice:
Notice that only the rows where the Region does not contain “East” are returned.
Example 2: Filter for Cells that Do Not Contain One of Multiple Texts
Once again suppose we have the following data in Google Sheets:
We can use the following formula to filter for rows where the Region is not equal to “East” or West”:
=FILTER(A1:C17, REGEXMATCH(A1:A17, "East|West")=FALSE)
The following screenshot shows how to use this formula in practice:
Notice that only the rows where the Region is not equal to “East” or West” are returned.
Cite this article
stats writer (2024). How can I filter cells in Google Sheets to show only those that do not contain specific text?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-filter-cells-in-google-sheets-to-show-only-those-that-do-not-contain-specific-text/
stats writer. "How can I filter cells in Google Sheets to show only those that do not contain specific text?." PSYCHOLOGICAL SCALES, 26 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-filter-cells-in-google-sheets-to-show-only-those-that-do-not-contain-specific-text/.
stats writer. "How can I filter cells in Google Sheets to show only those that do not contain specific text?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-filter-cells-in-google-sheets-to-show-only-those-that-do-not-contain-specific-text/.
stats writer (2024) 'How can I filter cells in Google Sheets to show only those that do not contain specific text?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-filter-cells-in-google-sheets-to-show-only-those-that-do-not-contain-specific-text/.
[1] stats writer, "How can I filter cells in Google Sheets to show only those that do not contain specific text?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I filter cells in Google Sheets to show only those that do not contain specific text?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.