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.
84
questions
1
vote
0
answers
34
views
How to have multiple filters work at the same time in one formula?
I'm trying to make a filtered list. The information in the list depends on if multiple values are check or not.
In image one you have the ranks which I want to have one filter. Then the training type ...
- 11
0
votes
0
answers
4
views
Is there a method to count how many times an mp4 file has been played within window 10 file explorer?
I want to determine which videos are most useful so I can free up hard drive space. I also want to know which mp4's (or other file types)are my un biased favorites based on usage.
I know that there ...
1
vote
1
answer
42
views
Google Sheets Select Row that contains text and transpose it in a single step
I'm trying to select a row of data from my table based on text in columns A and B and then transpose it into a column. In my example, I would like to just have Minnie Mouse's information in a single ...
- 11
3
votes
1
answer
618
views
Gmail failing to catch spam from ml top-level domain - can I block all .ml addresses and send to spam?
Gmail is failing to catch many spam messages a day from addresses like "raw4gftvdg_sgthesry@dewasoqeyodruna.ml" All are .ml addresses and have the same sender "name". I've reported ...
- 31
3
votes
3
answers
299
views
How to filter to show data that contain numbers greater or equal to "x"?
I have a google sheet with data that contains a column that is mixed both with text and numbers. I want to filter all to see which have numbers greater or equal to $500,000.
or which column have the ...
- 33
0
votes
0
answers
8
views
Filter by specific no color label name not working
I have applied a no color label to a card. I would like to filter by that label, but I can't seem to do it. I can filter by the color labels applied, but it won't let me filter by the no color labels. ...
0
votes
1
answer
121
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 ...
- 3
1
vote
1
answer
26
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 separate for testing) filter working ...
- 111
-1
votes
1
answer
27
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, ...
0
votes
1
answer
19
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'!...
- 1
0
votes
1
answer
37
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 ...
- 31
1
vote
0
answers
396
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 ...
- 111
1
vote
1
answer
497
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 ...
- 35
0
votes
1
answer
97
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 ...
- 39
0
votes
1
answer
229
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 ...
2
votes
1
answer
50
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 ...
1
vote
1
answer
52
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(...
- 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 ...
- 11
0
votes
1
answer
351
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 ...
1
vote
1
answer
2k
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,...
- 25
1
vote
1
answer
267
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 ...
- 65
1
vote
1
answer
169
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 ...
- 135
1
vote
1
answer
250
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 ...
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")
...
- 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 ...
-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 ...
2
votes
2
answers
459
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 ...
- 167
1
vote
2
answers
30
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 ; "
- 145
0
votes
2
answers
38
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!
1
vote
2
answers
164
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 ...
- 13
1
vote
2
answers
729
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....
- 159
1
vote
2
answers
118
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 ...
- 11
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.
...
- 215
2
votes
3
answers
2k
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.
...
- 81
0
votes
1
answer
328
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 ...
- 15
1
vote
1
answer
572
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 ...
- 13
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
...
- 15
1
vote
1
answer
797
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 ...
- 11
2
votes
1
answer
92
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 ...
- 23
1
vote
1
answer
105
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?
- 25
1
vote
3
answers
390
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&...
- 37
1
vote
1
answer
78
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 ...
1
vote
1
answer
37
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
1
answer
55
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 ...
- 1
1
vote
1
answer
62
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 ...
- 11
2
votes
2
answers
2k
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 ...
phLOx
1
vote
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'...
SJS
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"))
...
0
votes
1
answer
524
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
2
answers
42
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 ...
