Questions tagged [google-sheets-filter]
Use this tag for questions about using the filter feature of the user interface of Google Sheets.
178
questions
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 ...
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 ...
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 ...
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 ...
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 ...
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.
...
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 ...
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 ...
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 ...
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 ...
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:...
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 ...
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 ...
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 (...
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 ...
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)); ...
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 ...
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....
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(...
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 ...
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'...
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 ...
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 ...
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 ...
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 ...
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 ...
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:...
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)
...
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 ...
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:...
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(...
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 ...
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 ...
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 ...
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)...
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 ...
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.
...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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" ...
-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, ...
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'!...
-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 ...
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 ...
-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 ...