Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [filter]

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.

0
votes
1answer
11 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")) ...
0
votes
1answer
29 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 ...
0
votes
2answers
12 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 ...
1
vote
1answer
21 views

Return a value from a column if multiple criteria are met

Can anyone teach me how I can return a value from a column if multiple criteria are met where if: a cell in a column of another sheet contains a word in a cell (referenced) the same row in another ...
1
vote
1answer
12 views

How can I divide row data into multiple Sheets and have sort work corretly?

Say I have a Sheet with people info, containing their names and some other info. I add a filter to this Sheet to be able to sort alphabetically by lastname, or any other column. Now I want to add ...
0
votes
1answer
13 views

FILTER has mismatched range size; referencing the second last cell in a column in range

I am using a multicriteria filter to check if my sheet contains a certain value combination. The formula should automatically include any new rows added to the sheet. However, if I do it this way: =...
1
vote
1answer
22 views

Filtering Pivot table by multiple values

I have a pivot table below that I am trying to filter dynamically based on a separate list and am trying to figure out how to do this by referencing the relevant field. In the below example I have ...
1
vote
1answer
12 views

Using Google Sheets to dynamically add entries to column based on logic?

I have a list of people that I have a drop down for if they are attending or not to an event. If "Yes" I want them to be added to another column on sheet 2. Except I don't know how to add them ...
1
vote
1answer
16 views

Extract Value from Poorly formed JSON result

I have a Google script that returns the following result set, but when I try to get the value for asking_price or asking_price_condition it comes back undefined. I assume it's because of some {} ...
-2
votes
3answers
29 views

Parsing a non-nested JSON string in Google Sheets using formulas only

I have a cell with the following JSON data: {"rev2_0": "2,058", "rev2_1": "2,099", "rev2_2": "2,141", "rev2_3": "2,184", "revchg3_0": "3%", "revchg3_1": "6%"} In another cell, I want to get the ...
2
votes
1answer
27 views

Sum value in cells that contain both number and text

I need to sum a range of cells with text in them. Example: a1= "25,00 market" b1="24,00 credit card" c1="75,11 food" a2= "10,00 sweets" b2="9,00 market" c2="24,00 keyboard" I want to sum ...
1
vote
3answers
57 views

How to return what is missing from a 2 column list comparing against all possible combinations of 2 single column lists?

Sample data: A B C D E F 1 name handed in students assignments name missing 2 a 1 a 1 b 2 3 b 1 b 2 ...
0
votes
2answers
17 views

How to apply conditional formatting only if cell has X value? [google sheet] [duplicate]

I have a sheet with statistical data to which I had applied color scale conditional formatting. Some rows I set to have green for highest and red for lowest number in row and other rows the other way ...
0
votes
2answers
14 views

FILTER for multiple conditions including OR

How can I use FILTER in a single formula to check for multiple conditions, such as in this case? The filtered range must be equals1 AND notequal2 AND equals3 OR equals4 This is of course an ...
1
vote
2answers
27 views

Google Sheets' Query or Filter solution

I have a simple table with columns: A (Donor ID) B (Donation date) C (Donation Amount) I need to extract the following report: For each donor ID most recent donation date and amount donated ...
0
votes
1answer
87 views

Can you auto update the range for a filter in Google Sheets?

I have a Google Sheet document with many rows in it. I have several filters set up to view different collections of rows. The problem is, this sheet has new rows automatically added to it several ...
0
votes
0answers
33 views

Create Gmail Filters based on strings in the Doesn't Have field

As an Ebay seller, I currently filter all e-mails from Ebay to a folder. I would however like to keep those that contain "sent a message about" or "buyer opened a request" in the inbox so I can ...
0
votes
0answers
33 views

Can I create a Gmail filter that checks a sender's name in my contact list with the associated email address and sends email to spam on a mis-match?

I have a staff member, at a company I'm doing a little work for, receive emails with a spoofed sender's name. That is, where she would expect to receive an email from "Known Person" <known.person@...
1
vote
1answer
44 views

Catch New Rows in Existing Filter Views

I have a series of filter views that filter my Google sheet based on the values in column B. I have 200 rows in my sheet, so the range for each filter view is A1:C200. Often, new rows get added to ...
-1
votes
1answer
71 views

Create Gmail filter that checks whatever mail was classified as spam

I want to immediately delete spam mail from a specific domain. I want it to skip spam folder and be automatically deleted. I do not want to affect emails from this domain that are not marked as a ...
0
votes
2answers
160 views

How can 2 people use the same Gmail account and filter incoming e-mails for each user considering Labels are applied per message?

So this one is a serious head-scratcher that is proving much more difficult to resolve than at first glance. I have a Client that runs a small business. They are a husband and wife team and use ...
1
vote
1answer
43 views

Google sheets - display only rows containing a digit in range [1-9]?

I have very little knowledge of Google sheets but I need to filter column A (a list of URLs) to display, for example, only URLs containing a digit in the text string. I see there's a filter button but ...
1
vote
1answer
178 views

Copying values between Google Sheets

I have 2 Google Sheets. I have data on Google Sheet A and I would like it to automatically transfer some values to Google Sheet b. For example, I have some email addresses and some data associated ...
1
vote
2answers
37 views

Confirm that values in a column are alternating

I have a column, call it A, of around 1500 cells. Each cell contains either "a" or "b". For the most part, the As and Bs are alternating, but sometimes there are repeating values. An example of A1:...
2
votes
1answer
23 views

How to summary the multiple entry into a single sheet by name and by date?

Names are in rows and Dates are in columns. Sheet 1: Name 1-Jun-18 2-Jun-18 3-Jun-18....... KB CL KB EL AJ SL SD SL SD CL I need ...
1
vote
1answer
401 views

Compare two lists and produce a list of names not duplicated

I have one list of total available people and the second list of people who have been assigned. I would like to auto-populate a third list of the people (from the first list) who have not been ...
1
vote
1answer
35 views

Display progress of combined requirements based on values in other cells & sheets

I am compiling a reference sheet in Google Sheets for our Music group. We play covers and everyone in the group is able to contribute suggestions. These suggestions make up sheet 1. This sheet ...
0
votes
2answers
6k views

Google Sheets formula for “if contains” from range

I try to figure out how to get a value based on "if some word is in a range". So formulas from (Google Sheets formula for "if contains") works: =IF(ISTEXT(REGEXEXTRACT( A1, "sites")), 1,0) ...
0
votes
0answers
27 views

How do you filter AdSense ads via Doubleclick for Publishers? (DFP)

I have an AdSense account and a Google DFP account. On my AdSense account I have a screen for filtering out categories of ads that looks like this: Since DFP ad units have "AdSense inventory settings"...
0
votes
0answers
240 views

Google Sheets: Multiple tab data querying, filtering, and compiling

I have dozens of tabs on a google sheets worksheet that all utilize the same template, each cell utilizes data validation drop down menus--a plant information database of sorts. I would like to ...
2
votes
1answer
5k views

Google Sheets Filter Multi Column List With Another List Using A Function

I have two lists (A and B). I want to filter list "A" (a multi column list) with values in list "B" to create a Final List, list "C". List "A" has multiple records for each student ID number. List "B"...
0
votes
0answers
26 views

How to split a column of data into organized groups?

I'm a teacher and would love a way to organize how my students are doing for different topics. Using a google sheet like below, I organize how different students are doing with different skills by ...
1
vote
1answer
69 views

Has the Twitter search syntax silently changed?

So for the last few weeks I've been performing the following search: #MyHashTag filter:images And it has worked perfectly. Until yesterday/today when it stopped and displays zero results. Additional ...
1
vote
0answers
144 views

Google search by time frame anomaly

I'm trying to understand the logic Google search uses when I use the time frame filter. In the first search, I restrict results to "Past 24 hours": In the second search, I restrict to "Past week" : ...
2
votes
1answer
8k views

Query function with multiple criteria

I want to use the query function in Google Sheets to filter data from one tab (see data below) to another to meet the following criteria: F – No. Order = greater than 1 C – Area = City D – Color =if ...
2
votes
1answer
584 views

Dynamic range for filter function

I have the following formula: =iferror(sum(filter('November 2017'!$H:$H;'November 2017'!$D:$D=$B3)); 0) Which I use to categorize expenses in a Summary sheet: $B3 would be for example Rent, and this ...
0
votes
1answer
182 views

Google Analytics Exclude URI filtering

I have a tracking code which is currently used on two ORACLE APEX webapplications. (210 and 400). I have made a view in Google Analytics, which contains a filter that should exclude the 400 ...
0
votes
1answer
534 views

Filter YouTube to avoid spoilers

I do not know whether this is the right StackExchange site, but I would like to ask whether I can tell YouTube somehow (without installing add-ons to my browser) to top showing me anything related to ...
2
votes
1answer
56 views

Exclude “.NET” from a Google search for “Microsoft Net Server”

I'm trying to do some research on a product that I believe may have existed quite some time ago called Microsoft Net Server (cf. this article from 2000) which was apparently some sort of file server ...
-1
votes
1answer
1k views

Find latest entry of a duplicate row in Google Sheets

I have a spreadsheet that tracks the status of documents. Every time a document is worked on, a new row is added with that day's date and the new document status. This way I can track the progress/...
0
votes
1answer
67 views

Filter Twitter timeline by min_retweets

Twitter has these useful filters min_retweets: and min_faves. Is there a way to use them within my timeline?
1
vote
1answer
158 views

Join cells and headers value in a row with Google Sheets filtering blank cells

I would like to know how to filter and join each row adding the header before the values addin a ":" beetween Header and Value and separating them with ";". If the value is blank the header don't have ...
1
vote
1answer
395 views

How can I import rows from one mastersheet to another sheet where row has value “test”?

Mastersheet name: Recherche. Sheet name where the data has to be copied to: Leads. Mastersheet has data filled from Column A4 to Column M4 (both going down to 1,000 rows), looking like this: ...
1
vote
0answers
23 views

outlook.com rules copying messages that should be moved

I have a web server that I set up to send all notifications that may be of use to debug/investigate server issues to my outlook.com account. I use this account as a backup in the case I lose access to ...
5
votes
1answer
63 views

How can I filter a set of data based on a column containing a given date in sheets

I have a set of data in sheets, and the first column is an automated date added record. I would then like to filter this data set on a number of criteria including whether the date added matches a ...
2
votes
2answers
130 views

Filter multiple categories Spreadsheet

How can I filter multiple words in a column? (for example, I want to filter the words golf and ski to show up in my filter)
1
vote
1answer
73 views

How to filter out exact phrases in an email filter?

I'm getting a bunch of spam emails along the lines of "Iphone, Get our new loans", "Iphone, subscribe to magazine" from completely different senders every single time, but the title is always a ...
4
votes
1answer
5k views

Filter a range by both Row and Column criteria in Google Spreadsheets

I have a set of data that I want to filter by both the rows and columns. I want to create a function like FILTER(B4:L8, (B2:L2 = "Email")+(B2:L2 = "All"), A4:A8 = "Email") to filter the data in the ...
1
vote
2answers
192 views

How to filter everything in one column out of another

I have two columns. Column K has a bunch of values, Column L has some of these values. I want to filter everything that appears in Column L out of Column K. How would I do this?
0
votes
1answer
587 views

Filter/Query a column of names by an array of names [duplicate]

I have two columns of names in my spreadsheet. In column 1 I have a long list of names, in column 2 I only have 10 names. I want to filter column 1 in such a way that it will only display the names ...