Questions tagged [google-sheets-filter]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
9 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 ...
1
vote
2answers
50 views

Google Sheets, Reorder filter views list

Ive got a google drive spreadsheet with lots of filter views. Ive been adding them on an adhoc basis, and the list is growing a bit long making it hard to find the filters when i need them. Is it ...
0
votes
1answer
17 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....
1
vote
1answer
31 views

If values in a range appear in another range, remove from list in another cell

I've been stumped on this googlesheets problem and can't think of the best way to do this or I'm overthinking this. Essentially if I have a list of values, I'd like to compare it to another list of ...
1
vote
1answer
94 views

Syntax of field “Google Sheets / Pivot table editor / Filters / Filter by condition / Custom formula is”

In Google Sheets, if I create a pivot table, there is a Pivot table editor I can use to configure the pivot table. The lowest section of the interface of the editor is Filters (which allows me to add ...
0
votes
0answers
57 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
26 views

Show values from only rows that have a checkbox ticked

I have a data table with groups as column headers and names and emails as rows. I want to export data to another spreadsheet in the same document, which would only display members who belong to a ...
1
vote
1answer
34 views

Filter spreadsheet by user-entered value in first row

In Google Sheets, I want to set up a filtered view like this. Row 1 = column headings Row 2 = filter criteria Rows 3... = data I want the user to type a value into any column of row 2, and ...
0
votes
2answers
1k views

Why are sheet Filter Views not updating for new rows?

I have a sheet with two filter views, which apply filter on one column and sort on another. The sheet is populated from the API nightly - it has all worked great but today I noticed things in the ...
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
1answer
2k views

Copying filtered data in Google Sheets

What is the correct method for copying data in a filtered view in Google Sheets? For example, in the image below, I want to copy the cells with values 1 & 3 and paste them into the cells with ...
5
votes
2answers
10k views

Filtering a protected column

I'm trying to filter a protected column in a spreadsheet that I shared with other users. But I it looks like I can protect it or filter it with the other user but not both. In Excel I can do it ...