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.

30 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
1answer
63 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
0answers
63 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
1k views

How to pull last value in a Google Sheets column and populate it across another worksheet column?

This is my first post here- I hope this is the right place for it, apologies in advance if it isn't. Context: I have a password protected presentation that I need to give users access to, but only ...
1
vote
2answers
13 views

How do I detect duplicates in two worksheets?

I have 1 Google Sheet with 2 worksheets: Worksheet "1" has 1 column A with 5 lines of data (AAA, AAB, AAC, AAD, AAE) Worksheet "2" has 1 column A with 5 lines of data (AAA, BBB, CCC, DDD, EEE) I ...
1
vote
2answers
122 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 ...
1
vote
1answer
1k views

How to combine FILTER with TRANSPOSE in data validation custom formula

Cells A2, C2, and E2 contain the data I want to make my custom list for data validation. Cells B2 and D2 have data I don't want in the list (just text - "vs" - in them). So, I'm trying to use the ...
1
vote
1answer
27 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
2answers
15k 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) ...
1
vote
0answers
166 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" : ...
1
vote
0answers
24 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 ...
0
votes
0answers
9 views

Google Analytics subdirectory filter not showing any traffic (incorrect)

I've created a Google Analytics view to track all visits to www.example.com/wordpress/* This is the filter: However, this view shows no traffic. If I look at the default view that doesn't have this ...
0
votes
2answers
38 views

Help with a Vlookup function to return multiple results of not exact match

I am trying to run the following code to return all the matches of column A from column C in a set of rows. In this situation, cell A1, is contained in a few iterations of column C, however, these are ...
0
votes
1answer
12 views

Process visualization based on data

I am trying to use a Google spreadsheet to visualize a customer journey. I am trying to create the following graphic: I have created the following example spreadsheet: https://docs.google.com/...
0
votes
2answers
148 views

Make a filter but exclude one column

I would like to make a filter on Google Sheet but exclude one column For example: In this case I would like to have the filter on Column A and B but the data on Column B should stay as they are, so ...
0
votes
1answer
34 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 ...
0
votes
1answer
20 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 ...
0
votes
2answers
21 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!
0
votes
2answers
16 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 ...
0
votes
1answer
409 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. ...
0
votes
1answer
105 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 ...
0
votes
0answers
18 views

I have a specific excel list of emails that I would like to apply gmail filters to

I have an excel file of emails and I was wondering if it’s possible to get add gmail filters to the excel spreadsheet so that anytime a certain emailer emails me it will go straight to that gmail ...
0
votes
2answers
346 views

Conditionally format cells that not match with range from Sheet2

I have two sheets in the same file where "sheet1" has cleaned up information and "sheet2" has the dump from my jira. Now I am trying to compare Column F from sheet1 and sheet2 to confirm if they are ...
0
votes
3answers
27 views

Summing every other row depending on the classification of the row above

I've got a confusing question, I can't figure it out. I have this spreadsheet of states population and their political control, each on separate alternating rows (political control is designated with ...
0
votes
1answer
9 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 | ...
0
votes
1answer
35 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 ...
0
votes
1answer
29 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 ...
0
votes
2answers
20 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
2answers
25 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 ...
0
votes
0answers
27 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 ...
0
votes
3answers
563 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'...