2022 Developer Survey is open! Take survey.

Questions tagged [filter]

DO NOT USE THIS TAG. Filters are rules or parameters one uses in order to exclude or include certain content from either appearing in a query results page, list or being returned in a search result.

Filter by
Sorted by
Tagged with
0 votes
1 answer
30 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 ...
user avatar
  • 3
0 votes
1 answer
17 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 seperate for testing) filter working ...
user avatar
  • 101
-1 votes
1 answer
24 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, ...
user avatar
0 votes
1 answer
15 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'!...
user avatar
  • 1
0 votes
1 answer
11 views

Help with filter formula

So on Google Sheets I have this: =iferror(FILTER('RAW DATA 2'!$B$2:$G,'RAW DATA 2'!$B$2:$B>=$B$1,'RAW DATA 2'!$B$2:$B<=$B$2),""), the formula is working. However, I would like to skip ...
user avatar
0 votes
0 answers
13 views

How can I filter users that starred or forked a given GitHub repo?

Similar to this question I'd like to filter GitHub users that starred or forked a given GitHub repo. I'd like to apply the filter's GitHub offers as part of their search and, for example, list all ...
user avatar
  • 101
0 votes
1 answer
24 views

Gmail Label Conversation that were initiated by me

I need to apply label on only those conversations that were started by me. In the image attached, those conversations having the words (representing senders' nicknames) "me, Mail 2" means ...
user avatar
  • 21
0 votes
0 answers
28 views

Filter emails by time of day for all days in outlook

I am trying to visualize all emails that were sent between end and start of day (20:00 and 8:00) in an outlook inbox. I don't seem to find an option to filter emails by time of day alone, the filters ...
user avatar
  • 1
0 votes
0 answers
30 views

Create filter with one button click on Gmail

Every time I see a new newsletter in my inbox I want it to go into a specific label folder, be archived, and marked as read. I forget all the newsletters I sign up to, so I often have to do this ...
user avatar
1 vote
0 answers
121 views

Filter emails I have sent that have not been replied to in Outlook 365 on Windows

I'd like to filter my "Sent" folder for emails that have been sent to a specific contact and have not been replied to yet. I found this related solution but it is for emails that are in my ...
user avatar
  • 11
0 votes
1 answer
256 views

Gmail Filters for email Alias

I use gmail workspace for my work, its not @gmail.com but it's myusername@mycompany.com but we use it in google workspace, gmail, drive and all..Provided by the company.. We have lots of email aliases ...
user avatar
0 votes
1 answer
25 views

Using Index + filter in Spreadsheets

I would appreciate some help with this spreadsheet issue. I am trying to automate column B to find the next shipment in the restock row and column C to find that same shipment from the same restock ...
user avatar
0 votes
0 answers
23 views

How do I remove one specific category from showing up while browsing Twitch.tv?

I just really hate the horror category and would much prefer not to see it at all, even if it's from a streamer I follow currently. And I want to remove it from showing up in the list of games as well ...
user avatar
  • 111
1 vote
1 answer
308 views

Also apply filter to matching messages - Gmail filters

"Also apply filter to matching messages" Checking this box in a Gmail filter ONLY works when creating or editing a filter. The box apparently gets un-checked subsequently. I have a need for ...
user avatar
  • 11
0 votes
1 answer
111 views

REGEX in Google Sheets with Filter

I'm trying to mix regex with a filter in Google Sheets. What I have at the moment is =filter(AD:AD,X:X=X2,right(Z:Z,1)={1,2,3,4,5,6,7,8,9}) The regular expression is that the final character in ...
user avatar
1 vote
1 answer
33 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 ...
user avatar
1 vote
1 answer
29 views

Filter causing Circular Reference Error - Not obvious why?

I have 3 sheets. SheetA and SheetB contain data and a third sheet where I want to merge the contents of the SheetA and SheetB in it. I type this formula in the result sheet (the 3rd sheet): ={filter(...
user avatar
  • 113
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 ...
user avatar
  • 11
0 votes
1 answer
122 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 ...
user avatar
1 vote
1 answer
1k views

Sumif and filter using regexmatch with multiple criteria

I need to sum specific cells in 1 column (Q) based on if the other columns (R, S) have a certain word(s) within the cell. For example in the picture if a cell in R or S contains the word toy or green,...
user avatar
  • 25
1 vote
1 answer
201 views

Pull image or skip to next cell if empty

I am currently using Google Sheets to make a list of videos and thumbnails. I have various sheets titled: Frying, Stewing, Baking, etc. Within each sheet, there are only two columns which include a ...
user avatar
  • 113
1 vote
1 answer
123 views

Outputing Array Formula in one row

I came across the below array formula, which works really well, I'm just struggling to tweak it, and barely understand it's inner workings, but it's very good. Instead of displaying a total of stock ...
user avatar
  • 135
1 vote
1 answer
152 views

Solve errors in a series of FILTER functions within array brackets?

I have been working on a budget project on Google Sheets. My goal is for a range of data to be filtered by date (which is represented as an integer between 1 and 31 for the day of the month). All ...
user avatar
0 votes
1 answer
2k views

How to combine these funcions (FILTER + IMPORTRANGE) in one? [duplicate]

I have all data in one sheet and I need to filter the imported data to another sheet. How can I do that in one function? Function to filter data which I use: =FILTER(A7:C,RIGHT(A7:A,7)="?id=999") ...
user avatar
  • 1
0 votes
1 answer
1k views

COUNTA and FILTER returning a 1 when it should return a 0

I am using a summary page to show stats from a registration page. I want to show the number of registrations based on their date of registration (which is in column A of the Registrations page. I ...
user avatar
-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 ...
user avatar
2 votes
2 answers
370 views

Perform functions (AVERAGE, STDEV) on rows grouped by unique values in Google Sheets

I would like to be able to group rows based on unique values and then output the AVERAGE and STDEV values for those groups. Using the table below as an example, I would like to determine the AVERAGE ...
user avatar
  • 157
1 vote
2 answers
25 views

How to get a true when a character is NOT in range

I want to filter all cells in a range which are not empty and does not contain a certain character. So I tried everything with regexmatch =filter(Planning!G$5:G$37; regexmatch(Planning!G$5:G$37 ; "![...
user avatar
0 votes
2 answers
31 views

Copy other cells if EITHER column has specific text

In a single sheet wanting to copy D3:N if either B3:B or C3:C = S2. I'm sure there is a simple formula to do this I am just unable to find it!
user avatar
1 vote
2 answers
156 views

Copy the contents of a row to another sheet based on a specific value

I have a Google sheet with various rows of data, in one column (Column E), the values for each row follow the following pattern: A1 A2 B1 B2 C1 C2 etc. I want to copy the rows ...
user avatar
  • 13
1 vote
2 answers
215 views

Counta unique string on filtered list

I'd like to count unique string values on a filtered list (For example, the value should be 3 in this screenshot): How can this be done in google sheets? Here's the spreadsheet: https://docs.google....
user avatar
  • 159
0 votes
2 answers
60 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 ...
user avatar
  • 1
1 vote
1 answer
3k views

QUERY with Week Number

I use query to extract two columns from another sheet with data. Column A has dates Column B - numbers I want to extract only rows that correspond to a specific calendar week number. For example 19. ...
user avatar
2 votes
2 answers
1k views

How can I allow results from a Google Sheets 'filter' action to be mutable?

Brief: The results of a filter are not mutable. I cannot directly add/edit rows to the cells in and around a filter result due to a #REF Error: not expanded because it would overwrite data error. ...
user avatar
  • 81
0 votes
1 answer
128 views

Filter column based in other column (using query prefer) [duplicate]

I am trying to make a filter with a query based in a column, but I cannot make it works. https://docs.google.com/spreadsheets/d/1zKMW8vuyHRpS8eVEmRgAOg_dBQ0r2OIXnqV3_TFEm9o/edit?usp=sharing This is ...
user avatar
1 vote
1 answer
515 views

COUNT UNIQUE values by group ONLY IF NOT already counted in previous group

I hope to explain clearly what I'm trying to do. I have some data in column B, grouped as shown in column A. I'd like to count the unique values for each group present in column A, not taking into ...
user avatar
1 vote
3 answers
1k views

How to use FILTER to select only values repeated more than X times

I am trying to use the filter function to select from 2 columns, only the values repeated. I will give you an example: My column is like: Names Jobs Value - Gerard player 4 Gerard player 2 ...
user avatar
0 votes
1 answer
726 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 ...
user avatar
  • 1
2 votes
1 answer
91 views

How do I filter really tiny columns in Google Sheets?

Sometimes in my filter views, whenever I have really small columns, the triangle icon to filter them does not show up at all. I'm able to temporarily resolve this by expanding the column, but it's ...
user avatar
1 vote
1 answer
51 views

How do I get rid of the blank line when I use UNIQUE in Google Sheets?

I used unique... the result is in column B, but I want results to look like column C. So what do I need to do to achieve this?
user avatar
1 vote
3 answers
369 views

Filter cell data using Query/Importdata

I am attempting to grab data from a cell, by using additional data in the cell above it to make sure its correct. Here is the data, each line is put into a cell by the formula. <total_count>6&...
user avatar
1 vote
1 answer
65 views

Conditional Formatting using Google Sheets

So I'm trying to build out a simple campaign tracker and I've been running into a few issues with the conditional formatting on google sheets. I need the cells on column C to change color and format ...
user avatar
0 votes
1 answer
33 views

Cross Comparing values between two columns for voting purposes

The current content of our Google sheet, is formatted as such: - PERSON 1 | PERSON 2 | YES - PERSON 1 | PERSON 3 | YES - PERSON 2 | PERSON 1 | YES - PERSON 2 | PERSON 3 | YES - PERSON 3 | PERSON 1 | ...
user avatar
0 votes
1 answer
53 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 ...
user avatar
0 votes
1 answer
55 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 ...
user avatar
2 votes
2 answers
1k views

Is there a way to autofill cells with a formula targeting cells horizontally (in rows) while autofilling vertically (in columns)?

In the above image fields are populated as follow: A1 is empty/not important B1 = animal C1 = dog D1 = male E1 = animal F1 = cat G1 = male H1= insect I1 = ladybug J1 = unknown I am working in column ...
user avatar
0 votes
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
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")) ...
user avatar
0 votes
1 answer
452 views

How to count how often a value is submitted to a Google sheet via Google Forms per day, and put that count in different Google Sheets workbook

I have two Google Sheets workbooks, Workbook A and Workbook B. Workbook A is generated from a Google form that collects email addresses submitted from users. Workbook A has two columns next to each ...
user avatar
0 votes
2 answers
38 views

How to count duplicate names as one value in Sheets?

I have a large dataset in Sheets and I'm grouping together the data in a pivot table and have a hard time figuring out how to avoid counting every instance of a name instead of counting the name as ...
user avatar