Stack Exchange Network

Stack Exchange network consists of 174 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
9 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
1answer
10 views

Can I move my filter beyond the first row?

I need to filter a spreadsheet but don't want my filter to be present on the first row as it's including the filter headings within the sort. Is there a way to filter a sheet but exclude the top 3 ...
0
votes
0answers
27 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
28 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
15 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
59 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
147 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
36 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
33 views

Google Sheets - 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
0answers
25 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
202 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 ...
0
votes
0answers
23 views

Remove duplicate rows but preserve specific values in Google Query

I have a google query formula in Google Sheets that outputs a set of data like this: Col1 Col2 1 Blank 2 A 2 Blank 3 Blank 4 Blank 4 B 4 C 5 Blank 5 D How could I ...
2
votes
1answer
4k 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
25 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
68 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
137 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
5k 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
505 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
142 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
456 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
847 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
59 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
151 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
358 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
98 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
72 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
4k 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
139 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
574 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 ...
1
vote
1answer
346 views

Can I have Google search results always filtered?

Is there a way to have Google search results always filtered? I am constantly clicking on "only show results from the past year" and I would like to make this default.
7
votes
1answer
44 views

Is it possible to do a web search filtered for the user's comprehension level?

Do any of the major search engines support a filter to indicate the comprehension level of the user and thus to filter out content beyond their scope? So for example, if someone wanted to find results ...
3
votes
1answer
105 views

Is there a way to specify more precise site category in Google Search?

Is there a Google Search feature to show results from a very specific category? For example, show only results from software company websites, or social networking websites, etc. I am aware of a few ...
9
votes
3answers
780 views

Blocking stupid videos on YouTube

There are a lot of really stupid/trolly/fake videos on YouTube. I'd like to blacklist them forever when I see them, so I don't accidentally click on them in the future, and maybe block the uploader, ...
4
votes
1answer
370 views

Google Reader statistics and filter [closed]

I have over 200 subscriptions in my Google Reader and I'm reading almost 300 RSS entries everyday. So my problem is to determine most powerful sources for me. So what I need to see is the statistics ...
2
votes
1answer
709 views

Is there a way to filter messages into a certain folder in Yahoo! Mail?

Is there a way to filter messages into a certain folder in Yahoo! Mail (much similar to what is available in Gmail)?
2
votes
1answer
105 views

When connecting Twitter and Facebook, can posts be filtered?

I have both Facebook and Twitter accounts. I also use Linkedin. If I want a tweet to appear in my LinkedIn profile, I add the hashtag #in. Is there a way to do something similar with feeding ...
2
votes
1answer
477 views

Filtering Twitter feeds - removing @ posts from the feed

Is there a way to filter Twitter feeds so that I do not see the @replies of a given user? For example, I [generally] do not want to see the "@reply thanks"-type messages from companies to followers.
2
votes
3answers
847 views

Is there a way to filter tweets?

There is a certain young singer who I do not like but who is very popular on Twitter. Is there some way I can block tweets (aka make them invisible) so I don't have to look at his name anymore, and ...
1
vote
1answer
628 views

Routing my mail server through Google spam filters [closed]

I've been told in the past that Google had a free spam filter service. The service would allow me to point my MX records to Google, then they would forward all cleaned mail to my server. Is this ...
6
votes
3answers
4k views

How can I filter Amazon.com results to exclude 3rd party merchants?

I'd like to search Amazon.com for products that Amazon sells without having to see all the third party merchants products. I've tried using some userscripts and some chrome extensions that claim to ...
1
vote
1answer
358 views

Netflix filter / review downloads?

Is it possible to either filter or at least review Netflix movie downloads based on criteria like movie rating, nudity, obscenity, violence, etc?
4
votes
1answer
366 views

How do I look at just the reviews of the format I'm buying on Amazon

I just bought a Kindle but when I look at reviews of a Kindle book I see reviews of the paperback and hardbacks. How do I filter the reviews so I just see reviews specifically of the Kindle copy? ...
18
votes
7answers
8k views

Is there a way to filter RSS feeds in Google Reader? [closed]

I have a number of busy RSS feeds for which I only find a subset of the messages to be of interest to me. Is there a way to configure Google reader to only display certain RSS items that match ...