Skip to main content
Share Your Experience: Take the 2024 Developer Survey

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
3 answers
27 views

Finding strings from a list between 2 string conditions that are part of the list

In Google Sheets, I have a list of unique strings that I want to filter based on two conditions. These conditions are two strings within that list. Ultimately, I want to find all the strings, ...
pfnanc's user avatar
  • 43
0 votes
1 answer
12 views

Grouping or linking data I added on a sheet to its corresponding filtered data brought over from another sheet

The small towing company I work for uses Google sheets for our calls logs. I filter logged calls so that all police calls are copied from the "General Log" sheet and show up on a different ...
Jann's user avatar
  • 9
3 votes
1 answer
39 views

Place multiple values returned by FILTER into a single cell instead of multiuple rows

I'm using the FILTER function to return a short list of items from a separate sheet. This is my current formula in B2: =FILTER('In Care'!D2:D999, A2='In Care'!J2:J999) The results spill into the rows ...
Graham's user avatar
  • 133
0 votes
2 answers
45 views

How do I use google sheets to remove items as they are selected from a list that may include duplicates

I would like column C to be column A with everything in column B filtered out. Column A may have duplicates and those should carry over into column C, unless the same number of that item appears in ...
KyAnSan's user avatar
0 votes
0 answers
17 views

Googlesheets Filter or Query, to select values matching a Row by value and Column by IsBetween date range

I'm attempting to make a general Profit and Loss report in GoogleSheets. The data I am using is in a Summary tab Summary by Purchase Category. Each row in Col A represent a category, and Col D:O ...
Eli's user avatar
  • 1
0 votes
1 answer
26 views

Counta and Array_constrain formula in Google Spreadsheets

I am creating a sheet in google sheets to look like a dashboard from the below data. I am asked to create this with formulas. I am getting the filter part correct. But changing the values from filter ...
Ramya's user avatar
  • 1
1 vote
1 answer
16 views

How to include a cell value in a FILTER formula

I want to import data from the main datasheet (Sheet 1) into a person specific sheet based on if their name is in column E or F in sheet 1. Currently using the following formula =FILTER('Sheet1'!B8:D, ...
Int.Guest's user avatar
1 vote
1 answer
175 views

Stop Google Sheets from removing trailing zeros

Can anyone suggest a Google Sheets formula to stop removing trailing zeros? (but allow truncating to 6 digits after decimal? 00.000000 29.9918650 -93.958005 29.991865 -93.958005 (1mi:29.991865:-...
Most Interesting Man In World's user avatar
0 votes
1 answer
49 views

Filter row based on matching substrings in cell values of another row

I have some data from which I'd like to return only cells that contain specific text. In Row 1 I have a sequence of numbers, from 1 to 5, and in the row below each number a text string. I want to ...
Georgi Slaveev's user avatar
0 votes
1 answer
38 views

Using created filter to filter specific value base on other cells value

I can't seem to figure this out. I am wonder if it is possible to create a filter for a column, and then filter that column based on another cells value. So I have created a filter for A column which ...
Linkinpark's user avatar
1 vote
2 answers
101 views

How to filter a schedule to return a list of employees based on date and shift code?

In Google Sheets, I have an employee work shift scheduling sheet named Shifts2. Column A lists all employees. Row 1 is a list of dates in November. The remaining rows in columns B through AG contain ...
Maidenas's user avatar
0 votes
1 answer
580 views

Google Sheets ordering by dropdown choice

I'm completely new to sheets and am currently trying to set up a filter for a column. The column is set up to use dropdowns to pick a string. What I'm trying to do is order it by the text, but not ...
Adam's user avatar
  • 9
1 vote
1 answer
125 views

How do I ignore a few rows below the header (including header) when sorting data in sheets? [closed]

I want to leave the filter buttons at the top, where they are but begin sorting from where the checkboxes are.. Every way I try, the filter buttons move or it sorts the top "notes" area ...
Erik Koopmann's user avatar
1 vote
1 answer
107 views

Error when using the FILTER function to get the buyer's name, address etc [closed]

I work for an Amazon drop shipping business, and we have a spreadsheet of all the order information, including the order ID, quantity, cost, etc. I have a different spreadsheet with the buyer ...
Hadassah's user avatar
1 vote
1 answer
198 views

Google Sheet ImportRange embedded in filter with RegexMatch option

I have a complicated spreadsheet with multiple tabs that filter for various things. The raw data comes from a file that I must download as a .csv file each day. Looking for a way to simplify a bit. ...
Brian Nussbaum's user avatar
2 votes
1 answer
247 views

Edit and examine existing filter views in Google Sheets

I inherited a monster sheet that is pretty much constantly used by multiple persons. It contains several filter views. Is there any way to find out what exactly each filter view does without manually ...
Desiato's user avatar
  • 121
2 votes
1 answer
354 views

Can the Filter function's range argument be a reference to a cell whose value is a range reference?

I have this formula (simplified because it is long): =FILTER(range,C3=TRUE,range<>"") In place of range can I refer to the cell AC2 that would contain the range name? I have two ...
Genny's user avatar
  • 365
1 vote
1 answer
534 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 ...
Parker's user avatar
  • 13
0 votes
1 answer
1k 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 ...
LWC's user avatar
  • 1,228
0 votes
3 answers
96 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:...
Bryson Williams's user avatar
1 vote
2 answers
327 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 ...
Meir's user avatar
  • 23
2 votes
1 answer
3k 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 ...
Samuel Holland's user avatar
0 votes
1 answer
48 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 (...
Roozbeh E's user avatar
  • 103
1 vote
0 answers
173 views

How to have multiple filters work at the same time in one formula?

I'm trying to make a filtered list. The information in the list depends on if multiple values are check or not. In image one you have the ranks which I want to have one filter. Then the training type ...
LaafJoren's user avatar
2 votes
2 answers
403 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)); ...
Spedwards's user avatar
  • 215
0 votes
1 answer
54 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 ...
Spedwards's user avatar
  • 215
0 votes
1 answer
29 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....
Nick Res's user avatar
  • 101
0 votes
1 answer
67 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(...
Colin Mills's user avatar
1 vote
1 answer
665 views

Google Sheets Select Row that contains text and transpose it in a single step

I'm trying to select a row of data from my table based on text in columns A and B and then transpose it into a column. In my example, I would like to just have Minnie Mouse's information in a single ...
2 many shoos's user avatar
0 votes
1 answer
213 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'...
Gary K's user avatar
  • 5
0 votes
1 answer
60 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 ...
Martins Kruklis's user avatar
0 votes
1 answer
108 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 ...
jpfieber's user avatar
2 votes
1 answer
70 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 ...
Bazu's user avatar
  • 53
2 votes
2 answers
132 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 ...
dreamerdan's user avatar
0 votes
1 answer
16 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 ...
Jimmy Wall's user avatar
1 vote
0 answers
14 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:...
David Wiggins's user avatar
0 votes
1 answer
33 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) ...
user2926340's user avatar
1 vote
1 answer
29 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 ...
Fayyaz Nasir's user avatar
1 vote
0 answers
38 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:...
MarvelousMar's user avatar
1 vote
1 answer
118 views

How can I return more than one match result from the same search key? [closed]

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(...
Kyle's user avatar
  • 11
2 votes
1 answer
75 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 ...
d.lanza38's user avatar
  • 121
1 vote
1 answer
162 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 ...
Echo's user avatar
  • 13
0 votes
0 answers
62 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 ...
JW2022's user avatar
  • 5
0 votes
1 answer
1k 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)...
william holman's user avatar
0 votes
2 answers
755 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 ...
BeepBeepBoop's user avatar
0 votes
1 answer
47 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. ...
PTB's user avatar
  • 1
3 votes
3 answers
631 views

How to filter to show data that contain numbers greater or equal to "x"?

I have a google sheet with data that contains a column that is mixed both with text and numbers. I want to filter all to see which have numbers greater or equal to $500,000. or which column have the ...
purple's user avatar
  • 33
1 vote
1 answer
207 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 ...
Emma's user avatar
  • 11
0 votes
0 answers
57 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
6k 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 ...
Classified's user avatar