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
23
votes
6answers
33k views

How to export a filtered set of rows from a Google Spreadsheet?

Is it possible, when exporting a Google Spreadsheet into a CSV, to apply this operation only to filtered set of rows? I need to get in CSV exactly the rows which are visible on the sheet after a ...
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 ...
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 ...
1
vote
2answers
62 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 ...
1
vote
1answer
36 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 ...
1
vote
1answer
32 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
166 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 ...
1
vote
2answers
560 views

Restrict ImportRange to only visible rows [duplicate]

I need to restrict the ImportRange function below to show only visible rows as some of the rows are filtered and some of the rows are grouped. =importrange("WorkbookID","Sheet1!A2:K13285")
0
votes
2answers
2k 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 ...
0
votes
2answers
29 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 ...
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 ...
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
146 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
292 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 ...