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
2answers
47 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 ...
0
votes
0answers
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 ...
0
votes
1answer
28 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 ...
0
votes
0answers
16 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 &...
1
vote
1answer
65 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 (...
0
votes
1answer
40 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 ...
0
votes
1answer
29 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 ...
0
votes
1answer
26 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 =...
0
votes
1answer
30 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 ...
0
votes
1answer
45 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 --...
0
votes
1answer
48 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 ...
0
votes
2answers
44 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 ...
0
votes
1answer
16 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 ...
0
votes
1answer
19 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. ...
1
vote
1answer
20 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 ...
0
votes
2answers
25 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 ...
0
votes
0answers
7 views

Need to only display table results in between 5 hours ago and now

I Have a table with data, the first column containing a timestamp. I want to display only rows in that table with times between 5 hours ago and the current time. I've been trying to filter with the ...
0
votes
0answers
23 views

Google Sheets - How to create an auto-update for a filter?

I have a spreadsheet that I am trying to hide large chunks of rows at once through my filter. Basically my file is a number of items under several large headers. I've made a seemingly empty column A, ...
1
vote
1answer
546 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(...
0
votes
2answers
111 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 ...
0
votes
1answer
46 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=&...
1
vote
1answer
60 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, (...
0
votes
1answer
47 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 ...
0
votes
1answer
68 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
287 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
0answers
488 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
1answer
141 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
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 ...
0
votes
1answer
50 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
1answer
34 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 ...
2
votes
0answers
256 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 (...
0
votes
1answer
55 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 ...
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
1k 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
1answer
5k 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
55 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
50 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
2answers
255 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
36 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
324 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
1answer
461 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("...
1
vote
2answers
169 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
34 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
2k 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 ...
4
votes
3answers
3k 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
2k 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
198 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
3answers
5k 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 ...
2
votes
1answer
82 views

Google Sheets sort question

I used to know this a few years ago and for the life of me can't figure it out and can't find an answer in Google help. I know how to sort columns, but only by the default A-Z format, how can I sort ...
4
votes
1answer
8k views

Can you auto update the range for a filter in Google Sheets?

I have a Google Sheet document with many rows in it. I have several filters set up to view different collections of rows. The problem is, this sheet has new rows automatically added to it several ...