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
21 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
63 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
35 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
41 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
27 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
134 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
1 vote
0 answers
60 views

Edit and examine existing filter views in Google Sheets [closed]

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
  • 111
2 votes
1 answer
204 views

Google Sheets - Refer Filter range to a cell?

I have this formula (simplified because it is long): =FILTER(RANGE1,(C3=TRUE), RANGE1<>"") In place of range can I refer to the cell , AC2, that would contain the range name? That is ...
Genny's user avatar
  • 345
1 vote
1 answer
123 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
577 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,206
0 votes
3 answers
59 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
213 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
1 vote
1 answer
2k 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
32 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
140 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
238 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
33 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
25 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
36 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
325 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
122 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
50 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
91 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
56 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
109 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
14 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
21 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
32 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
99 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
112 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
45 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
705 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
365 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
28 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
451 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
162 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
53 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
5k 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
1 vote
1 answer
144 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 ...
Sebastiani Romagnolo's user avatar
0 votes
1 answer
575 views

Filter from specified columns and display results into 1 column

I've got 2 sheets setup with exactly the same format (need to split up data because sheets are getting too long) and I'm currently able to filter through 1 column, see if there's any content, and if ...
Andrew's user avatar
  • 3
1 vote
1 answer
37 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 ...
Davbog's user avatar
  • 111
0 votes
0 answers
95 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" ...
Edward Falk's user avatar
-1 votes
1 answer
60 views

Fantasy Football league stat tracker

I am the commissioner of a small tabletop football league in Southern California. I'm currently using a league template spreadsheet to track individual player stats (TDs, passes, etc.), match results, ...
Ry Finerty's user avatar
0 votes
1 answer
20 views

How to import data from one sheet to another based on 2 cell criteria

I am trying to manage my sheet by using filter formula using 2 criteria is this possible or do I do I need to use another formula. what I am using is =Filter('Form Responses 1'!B2:U,'Form Responses 1'!...
Nsmjc's user avatar
  • 1
-1 votes
1 answer
33 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 ...
Phoebe's user avatar
  • 1
0 votes
1 answer
56 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 ...
GoremanX's user avatar
-1 votes
1 answer
113 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 ...
Josh's user avatar
  • 1