Skip to main content

Questions tagged [google-sheets-filter]

Use this tag for questions about using the filter feature of the user interface of Google Sheets.

Filter by
Sorted by
Tagged with
51 votes
6 answers
82k views

How to export a filtered set of rows from a Google Spreadsheet?

Is it possible, when exporting a Google Spreadsheet into a CSV, to apply this operation only to filtered set of rows? I need to get in CSV exactly the rows which are visible on the sheet after a ...
Stan's user avatar
  • 619
40 votes
3 answers
86k 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 ...
Rushmik's user avatar
  • 441
26 votes
4 answers
74k views

Filter multiple values using filter by condition tool in Google Spreadsheet

I'm trying to filter a long list of URLs to narrow down which ones I'm interested in. I've got my URL list in Google Spreadsheet and I'm using the filter tool to remove data that I don't want. At ...
sam's user avatar
  • 6,979
12 votes
4 answers
4k 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 ...
Spongebob Squarepants's user avatar
8 votes
2 answers
29k 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"...
Mr. B's user avatar
  • 2,877
5 votes
3 answers
13k 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 ...
Jason's user avatar
  • 51
5 votes
4 answers
32k views

Why are sheet Filter Views not updating for new rows?

I have a sheet with two filter views, which apply filter on one column and sort on another. The sheet is populated from the API nightly - it has all worked great but today I noticed things in the ...
Mr. Boy's user avatar
  • 568
2 votes
2 answers
600 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 ...
Corey's user avatar
  • 167
2 votes
4 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. ...
Homer's user avatar
  • 81
2 votes
2 answers
2k 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)
Florina Adriana's user avatar
1 vote
1 answer
356 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?
YYY Trade's user avatar
1 vote
1 answer
1k views

How does one automatically update rows/data with a Slicer filter when a spreadsheet is edited?

How does one automatically update a Slicer when data is changed on a spreadsheet? I would like it so that when I change cells and data on the spreadsheet, the Slicer filter will automatically update (...
ninjagecko's user avatar
1 vote
1 answer
10k views

Search multiple individual text strings, using "text contains" in Google Sheets

How can I search using the "text contains" filter option in Google Sheets for multiple individual strings of text? Currently I can search individually for "amazon" or "AMZ" but I would like to ...
sam's user avatar
  • 6,979
1 vote
1 answer
636 views

Separating responses to different Sheets in Google Sheets

https://docs.google.com/spreadsheets/d/1oWXZYCoKK_dqu8ONcTGqOU4pNBlypi3X7ES7uH7vcNQ/edit?usp=sharing (Disclaimer: First time ever using Sheets/Forms and I am not great with Excel Either) I have a ...
Parker's user avatar
  • 13
1 vote
1 answer
241 views

Stop Google Sheets from removing trailing zeros

Can anyone suggest a Google Sheets formula to stop removing trailing zeros? (but allow truncating to 6 digits after decimal? 00.000000 29.9918650 -93.958005 29.991865 -93.958005 (1mi:29.991865:-...
Most Interesting Man In World's user avatar
1 vote
3 answers
10k 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 ...
dlanmaar's user avatar
1 vote
2 answers
2k views

Restrict ImportRange to only visible rows [duplicate]

I need to restrict the ImportRange function below to show only visible rows as some of the rows are filtered and some of the rows are grouped. =importrange("WorkbookID","Sheet1!A2:K13285")
tedpenner's user avatar
0 votes
1 answer
33 views

Reference row url when using filter fucntion

I have this function that reference a specific cell =filter( { Data!E2:E, "https://docs.google.com/spreadsheets/d/id/edit#gid=123&range=E" & row(Data!E2:E) ...
user2926340's user avatar