Skip to main content

Questions tagged [google-sheets-filter]

Use this tag for questions about using the filter feature of the user interface of Google Sheets.

41 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2 votes
1 answer
58 views

FILTER between columns

I have thousands of data in 2 columns First one is ordered by export and the other by latest activity. The export columns has more queries than the latest activity. (can't change the export to the ...
Quinten De Wilde's user avatar
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
0 answers
174 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
1 vote
1 answer
710 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
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
1 vote
1 answer
31 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
210 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
1 vote
1 answer
213 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
1 vote
1 answer
76 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 ...
Roman Peresadyuk's user avatar
1 vote
2 answers
53 views

Searching Multiple Columns From Single Source Sheet in Google Sheets

I have a Sheet where I have all of my data entered. I have been able to filter the information to other sheets no issues when only searching in one column. I am having issues when trying to search 2 ...
CanadianTexanFC's user avatar
1 vote
0 answers
15 views

Data has both text and number, I need to move to another sheet from master but only the numbers show up...I need both

I've used this formula =query('Form Responses'!1:136,"Select * Where E='name'") but all I get is the numerical value entered in a cell. If someone enters both a number and text the cell is blank. In ...
Amy's user avatar
  • 11
1 vote
0 answers
16 views

Transform table: Get N top results for each row and replace with header value

I' having a table with names and countries as columns/rows: Goal: Sort each individual row by the N highest (or lowest) values and afterwards replace replace the values with the corresponding header ...
Fabian W.'s user avatar
1 vote
2 answers
48 views

Filtering on gathered statistics adds dummy empty rows and fails anyway

I have a simple data set: Pupil A Teacher A pass Pupil B Teacher A fail Pupil B Teacher B pass And want to compute the following statistics: Teacher pass rate Teacher A 50% Teacher B ...
g_user's user avatar
  • 11
1 vote
2 answers
228 views

Importing data found to be true from one Google sheet to another

I am trying to find a way to import data (text) from one sheet to another, via the same book. I assume it's going to need an IF or IFS formula because I only want data is that found to be "TRUE" (via ...
Soli's user avatar
  • 11
1 vote
1 answer
862 views

Filtering a QUERY using MATCH - how to pass column value into function? Or is there a better way?

I want to get a subset of data from another tab. Eventually, this will become a script and pull data from a different sheet. I can use QUERY to get all the data available, but I only want to return ...
Sarah's user avatar
  • 11
1 vote
1 answer
79 views

SUM across other worksheets (without hardcoding their names)

I've got a spreadsheet for my organisation's management accounts. Each project has a worksheet, setting out income and expenditure by financial year. This is aggregated together in a few sheets ...
Tom Chance's user avatar
1 vote
1 answer
52 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
  • 109
1 vote
3 answers
2k views

Google Sheets COUNTIFS Range of cells as criteria possible?

In the Google Sheets Formula =Countifs, is it possible to have a range as a criterion, for example: =COUNTIFS(ExampleSheet!A1:A10, "Some criteria", ExampleSheet!B1:B10, List_of_Names!C1:C) I couldn'...
user avatar
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
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
30 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
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
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,230
0 votes
1 answer
72 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
0 votes
1 answer
61 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
0 answers
64 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
1 answer
53 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
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
0 answers
158 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
0 votes
0 answers
19 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 ...
Phoebe's user avatar
  • 1
0 votes
1 answer
430 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 ...
D W's user avatar
  • 1
0 votes
1 answer
2k views

Filter rows which contain any value on a range of cells in a certain columns

I have a Sheet that contains a list of machines with their serial numbers, owner, date of begin of operation, status and many other parameters. I want to filter only the rows that contain the serial ...
Javi Hache's user avatar
0 votes
1 answer
2k views

I want to bring in already filtered data into a new spreadsheet

Is it possible to reference filtered data from one sheet to another in Google Sheets? I use the filter button to sort in a master sheet. I then use this formula in a new sheet: =IMPORTRANGE("...
Katherine Withrow-Mielo's user avatar
0 votes
1 answer
60 views

Auto sorting / copying data based on inputted data?

Sorry if this is a bit confusing or if I’m not explaining this well enough. Using my provided picture as an example how would one auto copy data that gets inputted into that table based on estimated ...
4tWinks's user avatar
0 votes
2 answers
51 views

How to work over rows from all other sheets in Google Sheets?

I have a 'summary' sheet and 12 other sheets named 'Jan20', 'Feb20', etc. In the summary sheet I have this formula (to calculate Uber costs): =FILTER('Jan20'!F2:F, REGEXMATCH('Jan20'!D2:D, "UBER")) ...
Sridhar Ratnakumar's user avatar
-1 votes
1 answer
98 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
-1 votes
1 answer
45 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
-1 votes
1 answer
143 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
-1 votes
1 answer
26 views

Generate Google sheet with selection from other sheet

I want to make a list of vegetarians in Document 2 from information in Document 1. Document 1 Columns A and B. Bill Meat Jane Veg Tony Meat Sarah Veg I want Document 2 to search ...
Rick Sander's user avatar