Questions tagged [google-sheets-filter]
Use this tag for questions about using the filter feature of the user interface of Google Sheets.
97
questions
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 ...
- 99
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(...
- 21
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 ...
- 25
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 ...
- 19
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)
...
- 159
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 ...
- 11
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:...
- 11
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 ...
user295118
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 ...
- 243
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" ...
- 245
-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 ...
- 3
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,137
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 (...
- 303
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 ...
- 113
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
=...
- 11
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
--...
- 3