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
1 answer
15 views

Filter formula & adding notes

Outline of spreadsheet. I have a spreadsheet we use to add daily shipments of products. This is added to daily so is constantly changing. Some of these are shipped nationally and some internationally. ...
user avatar
  • 1
1 vote
1 answer
25 views

Google Sheets Filter function w/ other function

I have two columns of data, one with names (A7:A), and one with percentages (B7:B). I am trying to use the filter function to show me the names of results with non-zero percentages. I also want to ...
user avatar
  • 11
0 votes
0 answers
29 views

How to eliminate negative numbers while tracking an interval

I have developed a sheet that tracks a daily event interval. When the interval passes midnight I get a negative number. e.g. -23:00:00. Ultimately I want to average the interval, but including the ...
user avatar
0 votes
2 answers
73 views

How to create a filter as a button on the Google Spreadsheet?

Someone created some filters for columns of data on a Google Sheet. But they created buttons for these filters on the sheet. Can someone tell me how this was done? I've attached a screenshot of ...
user avatar
0 votes
1 answer
25 views

Using filter function with alphanumeric data

I have a sheet of students and the classroom numbers that they visit throughout the day. I am trying to use a filter formula that returns the name of any student in a specified classroom. However, the ...
user avatar
0 votes
1 answer
19 views

Dual Filter, trying to equal one of a range

In Google Sheets, I have the following filter working which gives me a column range of values: =FILTER(INPUT!$E$2:$E, INPUT!$A$2:$A=B2) And a second (temporarily separate for testing) filter working ...
user avatar
  • 101
0 votes
0 answers
20 views

Is it possible to make a filter and search formula that imitates the Filter feature in Google Sheets?

I am making a database system using Google Sheets. I have successfully used the filter and search formulae but my problem is it only displays the data and it is not editable. I am looking for a ...
user avatar
0 votes
0 answers
24 views

Using cut/paste within a filter view causes data loss

The scenario: I'm editing a rather large sheet. I realize that all the entries with "Alice" in their title should go under the "Caribou" column rather than the "other" ...
user avatar
0 votes
1 answer
17 views

Google Sheets Filter View Question

I am trying to create a filter to sort some data and all the sudden my usual method isn't working. In column B I have set the filter to values W and G and then when I go to set the same values in ...
user avatar
  • 1
0 votes
1 answer
30 views

Highlight value in column based on list of values in other column that's on the same line as another value

Is that subject confusing enough? Here's my spreadsheet: https://docs.google.com/spreadsheets/d/1pksa5_7R2TuPaufIS8mPl6gxZ8aPoMdEfkebKsx1YKI/edit?usp=sharing It's for calculating speed@RPM for an ...
user avatar
0 votes
1 answer
16 views

Filter columns with a dropdown

I need your help with a somewhat dynamic drop down filter. I have a drop down list in cell B6 that states categories that appear in column "E". Below the drop down list I have a table with 5 ...
user avatar
  • 1
0 votes
0 answers
18 views

Need helping knowing how to process this data in Google Sheets

I need to sort this data in Google Sheets. I have names and then each name has 4 letters assigned to it, one in each column. An example is I need to know everyone who has a T and an I in column B and ...
user avatar
  • 1
0 votes
0 answers
14 views

Google Sheet search to return data from additional rows below

=transpose(FILTER({Log!S:S,Log!Y:Y,Log!Z:Z!AB:AB},Search(B37,Log!S:S))) returns adjacent cells in all rows it finds. How can I also get cells from the same columns n rows below from where search ...
user avatar
0 votes
1 answer
168 views

Filter by Condition in a list using custom Formula

I've googled this various different ways, but haven't found anything that has worked. I have a list that needs to be Private filtered by condition using a custom formula in google sheets. In Sheet2 I ...
user avatar
  • 1
0 votes
1 answer
31 views

Filter function in Google Sheets

I need help filter some data in Google Sheets. I want to create a FILTER() function that filters between 2 columns and also discards duplicates. Something like the UNIQUE() function between 2 columns.
user avatar
  • 3
0 votes
1 answer
25 views

Add one field in a queried Field

I have to work with a weirdly formatted dataset. I have a sheet where lines represent different parts of a model (bike) The first columns are checkboxes to indicate witch models the part is in. So my ...
user avatar
0 votes
2 answers
91 views

How to filter or query only selected columns based on a dropdown

I have a sheet with data, theres a section laid out 8x9 with a layout approximately similar to below (didn't recreate all 9 rows): Red Orange Yellow Green Blue Indigo Violet Grey X - X - - - - - X ...
user avatar
  • 3
0 votes
0 answers
11 views

Filter data by Month from another sheet

I have a raw data sheet where Zapier sends form data, Email, Phone, Date, and I need to separate these leads into separate Monthly sheets. how can I filter by Months second how to count the number of ...
user avatar
  • 49
0 votes
1 answer
78 views

Google Sheets: one query for Sum and Filter?

If I have a sheet with data like this: A B x 1 y 2 z 3 x 4 I can sum the values with =query(A:B, "select A, sum(B) group by A") How can I then filter this result? For ...
user avatar
0 votes
0 answers
117 views

Google Sheets FILTER function adding space after a period (first entry only)

I'm having an issue where, when filtering a range, the first entry (the one occupying the cell containing the formula)has a space added after the first period. ex. "0.Filter Data" reads as &...
user avatar
1 vote
1 answer
417 views

How does one automatically update rows/data with a Slicer filter when a spreadsheet is edited?

How does one automatically update a Slicer when data is changed on a spreadsheet? I would like it so that when I change cells and data on the spreadsheet, the Slicer filter will automatically update (...
user avatar
0 votes
1 answer
47 views

How do i Import a rows from one Google Sheet to another with filter?

I have a Google Form, the answers go to Google Sheets. I want to import answers from sheets (Аnswer) into new sheets but with a filter applied. For example: from sheets (answer) into a new table, I ...
user avatar
1 vote
1 answer
1k views

How do I exclude a list of values using a filter in Google Sheets?

In Google Sheets, I have a filter that does this: =FILTER(A:K, B:B <> "username1") That works to exclude all rows that have username1 in the B cell. But I want to exclude a list of ...
user avatar
0 votes
1 answer
100 views

referencing a column in a Google sheets array literal

Is there a way to refer to columns in a literal array like so: =FILTER({lengthy_arrayformula_1, lengthy_arrayformula_2}, condition referencing column 2 of the array literal in previous argument) or =...
user avatar
0 votes
1 answer
108 views

Return a list if 2 criteria match in Google Sheets

In an effort to organize staff training: So far I've made the pivot table, but I'd like for the pivot table to extract who needs which training, as a list in one cell. I tried using =JOIN, but I have ...
user avatar
  • 1
0 votes
1 answer
49 views

Google Sheet Filter and Match (List the label where a name exist.)

I have 4 game columns that contain the names of the players. I want to list the games of a particular player. A. B. C. D Basketball Bowling Billiards Badminton --...
user avatar
0 votes
1 answer
470 views

vlookup with multiple output and combining filter() with arrayformula()

I have 2 sheets : shot and deadline. https://docs.google.com/spreadsheets/d/1drNUQVtAxd0HU4QCVSKJSsKHoanE735n8HsjkYpYiGs/edit?usp=sharing This is my shot sheet : and this is the deadline sheet : So ...
user avatar
  • 195
0 votes
2 answers
142 views

Google sheets Sort by Header in View Mode

I wanna create a sheet with multiple columns of data... I would like to put sort options on the header columns.. so if one of the column is named PLAYERS NAME and then another Header is named AT BATS ...
user avatar
  • 1
0 votes
1 answer
21 views

How to get Google Sheets to show a sort by column UX?

NOTE: This question is NOT about how to sort rows by selecting them and then choosing Data->Sort Range Rather, I want to know if it's possible to add or enable a UX here there's a sort button on ...
user avatar
  • 773
0 votes
1 answer
20 views

Filtering views based on a cell having a value

I am trying to sort out a spreadsheet which has multiple columns in but don't really know where to start! I am looking to filter the sheet where column C has more than 3 errors for the ID on column B. ...
user avatar
1 vote
1 answer
29 views

No query result when one of the columns used in the output never has a value

I have a query where the output involves summing two columns. If either of the columns never has a value (given a set of filter criteria in the where clause), there is no result. Why? Here is an ...
user avatar
0 votes
2 answers
41 views

Searching Multiple Columns From Single Source Sheet in Google Sheets

I have a Sheet where I have all of my data entered. I have been able to filter the information to other sheets no issues when only searching in one column. I am having issues when trying to search 2 ...
user avatar
1 vote
1 answer
898 views

How to count filtered data when using slicer in Google Sheets

The sheet above shows data filtered by using Slicer. How can I count rows when I filter data by a column using the slicer? Let's say I want the counted result to appear in cell L4. If I use the counta(...
user avatar
0 votes
2 answers
283 views

How to filter Google Sheets by multiple contains using AND

I've searched for something similar but couldn't quite duplicate based on some other posts. Column F has data on which websites you have a login with. Let's say F2 = Amazon, Facebook, Google, Twitter ...
user avatar
0 votes
1 answer
74 views

How to use filter with multiple criteria in Google Sheet

I'm working with Google Sheet for healthcare purposes organizing patients lists and endorsement to team issues: =filter('CASES LIST'!C:R,('CASES LIST'!Q:Q="admission")+('CASES LIST'!Q:Q=&...
user avatar
1 vote
1 answer
164 views

How to filter Queried Data in an Array

Sample Spreadsheet: https://docs.google.com/spreadsheets/d/16p4M5UBODyBhmWFXYrA0FdLsA1FmwSmbrF12VUHlGaw/edit?usp=sharing I have this formula which works great: =ARRAYFORMULA(QUERY({Projects!A:C, (...
user avatar
  • 145
0 votes
1 answer
52 views

Align filtered results in Google Sheets

Sheet 1, Sheet 2 & Sheet 3 are in a single file. Sheet 1 (In order) [large list] Name Email A A@xyz //means A's email is A@xyz B B@xyz C C@xyz D D@xyz E E@xyz ... ... Sheet 2 ...
user avatar
0 votes
1 answer
334 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 ...
user avatar
0 votes
2 answers
581 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({'...
user avatar
1 vote
1 answer
767 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 ...
user avatar
  • 11
0 votes
1 answer
208 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 ...
user avatar
1 vote
0 answers
15 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 ...
user avatar
  • 11
0 votes
1 answer
61 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 ...
user avatar
  • 15
0 votes
1 answer
152 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 ...
user avatar
3 votes
1 answer
405 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 (...
user avatar
0 votes
1 answer
72 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 ...
user avatar
1 vote
0 answers
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 ...
user avatar
0 votes
1 answer
2k 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 "...
user avatar
  • 236
0 votes
1 answer
6k 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 ...
user avatar
  • 6,173
0 votes
1 answer
127 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 ...
user avatar