Questions tagged [google-sheets-filter]

Use this tag for questions about using the filter feature of the user interface of Google Sheets.

7 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
1answer
1k views

Catch New Rows in Existing Filter Views

I have a series of filter views that filter my Google sheet based on the values in column B. I have 200 rows in my sheet, so the range for each filter view is A1:C200. Often, new rows get added to ...
0
votes
0answers
3 views

How can I search multiple terms for “text contains” using a custom formula with the Google Sheets filter tool?

I want to use google sheet's filter tool to search multiple words under the "text contains" option. However, it only let's you search one term at a time. I have tried using different formulas under ...
0
votes
1answer
28 views

I want to bring in already filtered data into a new spreadsheet

Is it possible to reference filtered data from one sheet to another in Google Sheets? I use the filter button to sort in a master sheet. I then use this formula in a new sheet: =IMPORTRANGE("...
0
votes
0answers
13 views

How to reference a Named Range in a formula, if it is also the value in another cell

I have a Named Range named Car. In another tab, I have: A16 reproduces the header of the Named Range: =Categories!C1 A17 lists out the values in the Named Range: =FILTER(Car,NOT(ISBLANK(Car))) If ...
0
votes
1answer
18 views

How can I create a filter on Google sheets to filter only words that begin with uppercase?

I have a column with 2 kind of words: words without uppercase (betrachtet) and words that begin with uppercase (Analysieren) I need a filter that shows my only those words which begin with uppercase....
0
votes
0answers
156 views

Multiple filter Array formula in google sheets

I am trying to get my array formula to be able to filter on multiple drop down menus. I have 2 separate formulas that work but I cannot combine them. Is there a way to combine them to make the Array ...
0
votes
2answers
309 views

Make a filter but exclude one column

I would like to make a filter on Google Sheet but exclude one column For example: In this case I would like to have the filter on Column A and B but the data on Column B should stay as they are, so ...