We’re rewarding the question askers & reputations are being recalculated! Read more.

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.

Filter by
Sorted by
Tagged with
32
votes
2answers
58k views

FILTER(condition OR condition) syntax?

I am using FILTER() to display a value from Sheet 2 where the Name columns match. My problem is where I want: =FILTER(Sheet2!A:F, Sheet2!A:A="Combat Medic" OR Sheet2!A:A="Universal") as OR results ...
18
votes
7answers
9k 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 ...
11
votes
4answers
2k views

Average of last 7 non-empty non-blank cells in Google Sheets

I have numbers in range D7:D and there are times when some cells are empty. I want the average of the last 7 numbers but to skip blanks. So if in the last 7 there's only 3 that are full, I want it to ...
9
votes
4answers
894 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 sometimes block the ...
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 ...
5
votes
1answer
66 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 ...
4
votes
1answer
6k 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 ...
4
votes
1answer
637 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? ...
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 ...
3
votes
1answer
9k 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"...
2
votes
1answer
724 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
2answers
332 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)
2
votes
3answers
869 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 ...
2
votes
3answers
123 views

How to filter out a long list of sites from Google search?

I have a list of sites I would like to permanently exclude from Google search results. These are the large family of sites plagiarizing (and some of them garbling with machine translation) Q&A ...
2
votes
1answer
920 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 ...
2
votes
2answers
3k views

Query or filter the data where the start time is past 3:00 pm

I've started using Google Sheets for our logbook and it's been a great help. I have data with a time component in it (start and end time) and I'd like to query or filter the data where the start time ...
2
votes
1answer
106 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
22 views

ArrayFormula to create a table of data from 1 column

I have the below formula and want to turn it into an array. =INDEX($A:$A,ROW(A1)*5-5+COLUMN(A1)) I have tried it with the below attempt but only get 1 single cell result. =arrayformula(INDEX($A:$A,...
2
votes
1answer
35 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 ...
2
votes
1answer
54 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 ...
2
votes
1answer
3k 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: =...
2
votes
1answer
544 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 ...
2
votes
1answer
479 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
1answer
27 views

Google Sheets sort question

I used to know this a few years ago and for the life of me can't figure it out and can't find an answer in Google help. I know how to sort columns, but only by the default A-Z format, how can I sort ...
2
votes
2answers
356 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 ...
2
votes
1answer
44 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 ...
2
votes
1answer
14k 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
62 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
vote
3answers
6k views

Increment Cell Reference in Formula by 10

I have a spreadsheet that will have values every 10 rows. I'd like to make reference to them but I'm having trouble doing this by clicking and dragging the corner handle to fill out the cells. If I ...
1
vote
1answer
84 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 ...
1
vote
2answers
16 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 ; "![...
1
vote
2answers
2k views

How can I set the increment value for Google Spreadsheets to auto-increment?

OP Edit: I think I want Sheets to behave in a way it's not intended. I expected Sheets to recognize the incremented value in my formula the way I believe it recognizes the increment value in a ...
1
vote
1answer
63 views

Delete Google Sheet rows matching multiple criteria with custom formula

I have a Google sheet where I am trying to remove multiple rows matching any one of a vector of values using (Filter by condition -> Custom formula). For this example, let's say I want to remove ...
1
vote
1answer
35 views

Does Posteo.de support Sieve/Managesieve protocol?

Posteo.de offers filters which can be configured through the web UI. This function is however lacking function of the full set of sieve features which I'd get from filters defined through a ...
1
vote
1answer
19 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 ...
1
vote
2answers
24 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....
1
vote
1answer
146 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 ...
1
vote
1answer
15 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 ...
1
vote
1answer
64 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
2answers
457 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?
1
vote
1answer
348 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.
1
vote
1answer
629 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 ...
1
vote
1answer
360 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?
1
vote
1answer
18 views

Total Spent Formula in Google Sheets

So with my sheet, I am currently in the process of adding more stats in, I have looked into adding these stats by using Index & Match however it will only match to the first correct match it has ...
1
vote
1answer
39 views

Simplify multiple OR statements in a QUERY using IMPORTRANGE

I am trying to query values from a different sheet using a range from the current sheet. Is there a way to simplify the formula and get rid of all the ORs? Like maybe using a FOR loop? =QUERY(...
1
vote
1answer
15 views

How to display list of items that is in other sheet but not in the other? [closed]

As the title says, I need a column to show what is not on a range(BASIS) that is in the other sheet(BASIS) : I've been searching for hours now but only found the opposite results.
1
vote
1answer
18 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 ...
1
vote
1answer
23 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 ...
1
vote
0answers
56 views

How can I list all cards I am watching in Trello?

How could I list all watched cards (or as a further refinement all watched cards I am not working on)? I couldn't see anything immediately on the pages regarding watching, filtering or searching.
1
vote
2answers
67 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 ...