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
0 answers
16 views

What causes Google Sheets FILTER() range mismatch? [closed]

This formula =FILTER(dJournal!$A$5:I,dJournal!$B$5:B>"1") gives me this error: FILTER has mismatched range sizes. Expected row count: 998. column count: 1. Actual row count: 1, column ...
1 vote
1 answer
23 views

Separating responses to different Sheets in Google Sheets

https://docs.google.com/spreadsheets/d/1oWXZYCoKK_dqu8ONcTGqOU4pNBlypi3X7ES7uH7vcNQ/edit?usp=sharing (Disclaimer: First time ever using Sheets/Forms and I am not great with Excel Either) I have a ...
  • 13
0 votes
1 answer
48 views

How to filter a calculated field in Google Sheets?

Syntax of field "Google Sheets / Pivot table editor / Filters / Filter by condition / Custom formula is" is based on choosing a relevant field, then using the syntax to filter it. But ...
  • 1,128
0 votes
3 answers
20 views

Filter formula: Exclude data without a timestamp

=sort( filter( { Bryson!A4:S502; David!A4:S502; Justin!A4:S502; Michael!A4:S502; Manny!A4:S502; ScottC!A4:S502; ScottD!A4:S502; Zhenqian!A4:S502; Visitors!A4:S502 }, regexmatch({ Bryson!Q4:...
1 vote
2 answers
61 views

Google sheets - what function can I use to expand MAXIFS function to an entire column?

I'm trying to make the current column (most recent interaction date with client) display the max values (most recent dates) from ContactLog!b:b (dates of all recorded interactions), when the client ...
  • 23
1 vote
1 answer
212 views

Does Google Sheets have a 'Tag' system

I am making a google sheet showing details about a set of TCG cards and I would like to be able to filter the table to easily find cards that fit a specific criteria. With something like the cards ...
0 votes
1 answer
16 views

Is there any easy way to let spreasheet viewers filter content separated by Comma?

I have a video game list which contains their Genres in a second column, I've add each genre separated by Comma, all in one cell for each game, and I need a convenient way for viewers to filter (...
  • 103
2 votes
2 answers
96 views

Concatenating Google sheet ranges conditionally

I am currently attempting to union multiple ranges, but each range has to have a condition met first. My first attempt at this was the following formula: ={ IF(condition_one, range_one, IFERROR(0/0)); ...
  • 204
0 votes
1 answer
18 views

Counting instance of a string in a Google Sheets range

I have a few sheets available to me and I'm currently making a dashboard-esque sheet that just displays quick facts about the data as a whole. Before I explain what I'm trying to do, I will share ...
  • 204
0 votes
1 answer
18 views

How to build a table of imported data from conditional data sources

I have many spreadsheets where data will be added manually and which are all identical. Let's call these UserInputSpreadsheets. Inside each user spreadsheet are tabs with data which are also identical....
  • 101
0 votes
1 answer
18 views

Filter function outputting results differently depending on greater or less than

I am using a filter function to pull out numbers from a column. I have one function which is grabbing numbers over 101 and it is outputting them perfectly in two vertical cells this formula: =(filter(...
0 votes
1 answer
52 views

TRANSFORM ROW WISE DATA INTO ONE COLUMN CONSECUTIVELY based on the number of values in each row

I've learned how to use filters to organize row-wise data into columns and am taking that to heart in this spreadsheet! But I've hit a major snag. If you look at the example I've attached here, you'...
  • 5
0 votes
1 answer
43 views

Add data to certain columns if conditions of separate 1 or more conditions for data in each row are met

I have a table with "manufacturing quotes" and each quote has 1 or more parts in it (please see screenshot below). The data in parts1-3 (columns E-J) are filled, however, in reality, the ...
0 votes
1 answer
28 views

Google Sheets - Sum Filter of Table 1 in each row of Table 2

I have table of transactions with categories (let's say 1-5) and assigned dollar values, and another table with a list of each category. I want to sum up all the matching categories from Table 1 with ...
2 votes
1 answer
42 views

How to retrieve datas by a filter based on a merged cell?

In sheet1 (Source), I've a full calendar containing datas (dates in same row) On 30/10/2022 in AM, SHIFT 1 has to work with ITEM A On 30/10/2022 in PM, SHIFT 2 has to work with ITEM B... etc see ...
  • 53
2 votes
2 answers
76 views

Remove Inverted Duplicates [closed]

I've tried "Unique" and "Filter" in Google Sheets but so far it's not been easy. Maybe I'm overthinking it. I'd like to remove a set of duplicates from a list of names in two ...
0 votes
1 answer
8 views

Add a filter on a query from multiple sheets

I have a multi-sheet google sheet that uses a query, and I want to filter down the sheet called Hugo to only Hugo on Column G and then do the same on the sheet called Vivian where I filter down on ...
1 vote
0 answers
13 views

Query Filtering Corresponding Columns

Formula work in progress: ={query(C3:G82,"select * where D like '1' order by C desc, D asc LIMIT 1",0);query(C3:G82,"select * where D like '2' order by E desc LIMIT 1",0);query(C3:...
0 votes
1 answer
19 views

Reference row url when using filter fucntion

I have this function that reference a specific cell =filter( { Data!E2:E, "https://docs.google.com/spreadsheets/d/id/edit#gid=123&range=E" & row(Data!E2:E) ...
1 vote
1 answer
12 views

How can I use the filter option to only view names of agents that are in particular groups?

On the top rows are some groups that each agent is assigned. What I want is to use some kind of tool or formula that can display columns of those agents that have the desired groups. For example, if I ...
1 vote
0 answers
23 views

How do I filter in IMPORTRANGE using SEQUENCE and ARRAYFORMULA?

I am having issues with including a FILTER option in my current working formula listed below: =QUERY (IMPORTRANGE("1n7qMGR9p8xD-8tyPIhfrcyBEsW8FAUMJMHmgxM7xIVI","Consultant Directory!A6:...
1 vote
1 answer
61 views

Google Sheets - How can I return more than one match result from the same search key?

Link to sheet used: Testing Sheet Thanks to another answer I was able to match and return a single word from a search_key being compared to a specific range using the following formula: =UNIQUE(...
  • 11
2 votes
1 answer
68 views

Multiple sheet, relational lookups into aggregate function

Based on feedback in comments, this is a complete rewrite of the post, including the title. I am trying to create a Google Sheets document with 3 sheets (tabs). Two of the sheets are static data while ...
  • 121
1 vote
1 answer
52 views

Shopping List - If true ignore cell

I've made a spreadsheet that tracks what items I need to buy based on what recipies I want to make during the week. This is generated using a few different formulas and then displayed in column C. I ...
  • 13
0 votes
0 answers
25 views

How to filter and sort according to a preset order for a Query in Google Sheets

In Google Sheets, I'm using a query to pull all my data from different tabs into one master sheet. And now I'm wondering how to sort the data according to a preset order. The order I want to sort to ...
  • 5
0 votes
1 answer
106 views

Search across multiple columns for a value(s) return multiple row results

I am a rookie at this and I spent hours trying to figure this out but can find anything that really helps. Scenario 1: Looking at the photo. I want to search columns C through M for a selected color(s)...
0 votes
2 answers
39 views

How to fill a new google sheet with all rows that contain a specific value in a different sheet?

Imagine you have a google sheet which lists your favorite shops, types of shirts they have, and their price in separate columns. To find out which store has which shirts, you wish to filter out all ...
0 votes
1 answer
24 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. ...
  • 1
1 vote
1 answer
78 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 ...
  • 11
0 votes
0 answers
39 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
2k 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 ...
1 vote
1 answer
69 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 ...
1 vote
1 answer
26 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 ...
  • 111
0 votes
0 answers
21 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 ...
0 votes
0 answers
44 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" ...
-1 votes
1 answer
24 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 ...
  • 1
0 votes
1 answer
35 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 ...
0 votes
1 answer
60 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 ...
  • 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 ...
  • 1
1 vote
1 answer
738 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 ...
  • 11
0 votes
1 answer
36 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.
  • 11
0 votes
1 answer
28 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 ...
0 votes
2 answers
185 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 ...
  • 3
0 votes
1 answer
180 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 ...
1 vote
1 answer
817 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 (...
1 vote
1 answer
51 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 ...
1 vote
1 answer
3k 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 ...
1 vote
1 answer
227 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
1 answer
182 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 ...
  • 1
0 votes
1 answer
51 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 --...