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
25 views

How do I combine multiple results of two filter formulas in Sheets?

Share Link: https://docs.google.com/spreadsheets/d/1-SoQS5Y4EvExbYTOjBGdx7EAq4OYlS0sPENFsblrTr4/edit?usp=sharing Formula Currently: =CONCATENATE("[",FILTER('BLS - Occupational Employment ...
0
votes
2answers
45 views

Google Sheets FILTER function produces no result after certain start date

I have a sheet that is supposed to show which people are working where between a start date and an end date. The FILTER() function is in cell A3. =IFERROR(SORT( { FILTER({'...
0
votes
2answers
56 views

How do I count the amount of non-blank cells in a row, including only cells that are in a column that contains a specific value?

Here is my example sheet: https://docs.google.com/spreadsheets/d/1xxmTnRTaA0DPAyibbiXK00YPqhwT5NXH8kf8PtBh0jg/edit?usp=sharing I am trying to create a formula for the column "Total" that would ...
0
votes
2answers
35 views

Filtering on gathered statistics adds dummy empty rows and fails anyway

I have a simple data set: Pupil A Teacher A pass Pupil B Teacher A fail Pupil B Teacher B pass And want to compute the following statistics: Teacher pass rate Teacher A 50% Teacher B ...
0
votes
1answer
28 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
1answer
13 views

Filter rows which contain any value on a range of cells in a certain columns

I have a Sheet that contains a list of machines with their serial numbers, owner, date of begin of operation, status and many other parameters. I want to filter only the rows that contain the serial ...
0
votes
1answer
50 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
1answer
19 views

Google Query: filter one record per day/week per user

I'm collecting repeated measures using Google Forms which only allows 1 or unlimited responses. I need a way to filter out responses that were entered by the same user too near to each other. For ...
0
votes
0answers
47 views

Can I exclude the bottom row from a Filter in Google Sheets?

I have a spreadsheet in Google Sheets, there is a header and 13 rows containing data. There is then a row containing the average of the cells above. I'd like to be able to sort the various columns in ...
0
votes
2answers
2k 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 ...
1
vote
1answer
43 views

Google Sheets: filtering and matching a list treating NON-unique values

I have a list (column A) of non-unique text values. Items from that list are put into column B (via dropdown data validation). Any items from column A that are missing in column B are shown in column ...
3
votes
1answer
2k 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
24 views

Calculate average across rows that match an ID and a word - Google Sheets

Table is as follows: I want calculate the average of values in column C for rows with value "ABC" in column A and value "Yes" in column B. So, basically, the average of values 2 ...
1
vote
0answers
14 views

Data has both text and number, I need to move to another sheet from master but only the numbers show up…I need both

I've used this formula =query('Form Responses'!1:136,"Select * Where E='name'") but all I get is the numerical value entered in a cell. If someone enters both a number and text the cell is blank. In ...
0
votes
1answer
39 views

Filter for a QUERY function

I need some help here. So I need a function which imports selected columns from a different sheet out of which one of them contains a specified word but allows you to filter/ignore based on specified ...
0
votes
0answers
50 views

Why do Google Sheets filter ranges sometimes auto-expand to include new data, and sometimes don't?

When I create a filter in Google sheets, I want the range to automatically expand as I add/populate new rows. Sometimes, this works fine: When I have a column using “Checkbox” data validation (...
1
vote
0answers
14 views

Transform table: Get N top results for each row and replace with header value

I' having a table with names and countries as columns/rows: Goal: Sort each individual row by the N highest (or lowest) values and afterwards replace replace the values with the corresponding header ...
0
votes
1answer
201 views

How can I rename or delete temporary filter views in Google Sheets?

This is specifically about view-only sheets. This is specifically about temporary filter views. When I create them (Data → Filter views → Create new temporary filter view) they have a name like "...
0
votes
0answers
23 views

Same value to return multiple match in Google Sheets

I don't know if the title reflect the situation but here it is. I have this kind of information (image below) where: Column A : 1 serial for 100 cells Column B : 10 serials for 100 cells Column C : ...
0
votes
1answer
823 views

Search multiple individual text strings, using “text contains” in Google Sheets

How can I search using the "text contains" filter option in Google Sheets for multiple individual strings of text? Currently I can search individually for "amazon" or "AMZ" but I would like to ...
0
votes
1answer
29 views

Use a filter on an array of values

I want to create a spreadsheet which has an array of values split over 1 or more columns. I can do this successfully with the following formula: ={"Picard","Q","Data"} This puts each of these values ...
1
vote
1answer
46 views

Is there a way to do a “filter”, “if” function across multiple columns to only pull information based on certain criteria and headers?

I do not know how to explain this perfectly without a picture so please take a look at the image before reading. I am trying to filter the data in Fig 1 (Above). based on the headers and then if the ...
0
votes
0answers
27 views

Filter rows by value in column that doesn't exist yet

I'm working on a shared spreadsheet for a music camp. Multiple people in charge of the event (some with limited technical skills) will be using this spreadsheet. Last year, they wanted to look at just ...
0
votes
1answer
85 views

Google Sheets: Generate column in query based on reference range matches?

I'm no sheets expert, and I couldn't find the answer searching likely due to not using right search terms. Sorry if this is already answered and sorry if it's not possible. We have a data source that ...
0
votes
0answers
72 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 ...
1
vote
2answers
795 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")
25
votes
6answers
42k 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 ...
1
vote
2answers
106 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 ...
5
votes
2answers
11k 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 ...
1
vote
1answer
97 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
7k 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
1answer
3k 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 ...
1
vote
1answer
154 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
1k 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
2answers
410 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 ...