21

Old-school way: select filtered set of rows copy to clipboard create new sheet paste (or paste special -> paste values only) download this new sheet as CSV


16

Create a new sheet (Sheet2) within the spreadsheet. Set the A1 cell to be =filter(Sheet1!A:X, Sheet1!A:A>1). (See docs on the filter function.) You should then be able to save or export Sheet2 as CSV with only the filtered values.


3

At this time, on Google Sheets owner and users with permissions to edit a protected range are allowed to filter it. to edit saved filters. users without permissions to edit a protected range are not allowed to filter the protected range. to edit view filters created by others. are allowed to create temporary and to save view filters to edit own ...


3

The best way to do this is to just select the cells you want to save as CSV, paste it into notepad, then find/replace tab with a comma.


2

You can make a Pivot table for that, inserting the desired filter. Then just export it as CSV.


2

Follow this answer. Create a new sheet within the same document Use filter function (Set the A1 cell to be =filter(Sheet1!A:X, Sheet1!A:A>1)). (See docs on the filter function.) Import range from this new sheet.


2

Apparently in Google Sheets, when you turn on the filter (say on the first row) and you don't create a named filter view, that filter on the first row is still set with a range that only goes to the maximum number of rows that you have set up at the moment you turn on filters. If you add rows (not data to existing rows, but physical rows) to the spreadsheet,...


1

Google Sheet's Filter Views only work on the range specified. This range does not update upon the adding of rows or columns. The second issue, the number not being sorted, is because of the first one. Those cells are not in the range of the Filter View.


1

EDIT (following OP's request) To completely skip any header (display nothing instead of some words) please use =QUERY(A1:C4,"select avg(C) where A='ABC' and B='Yes' label avg(C) '' ") Please notice the pair of single quotes in the end You can use this query formula: =QUERY(A1:C4,"select avg(C) where A='ABC' and B='Yes' label avg(C) 'Average ...


1

You would just use and The only column containing a different variable is column B. So you could use =query(Sheet1!A:F, "SELECT A, B, C, D, E, F where E contains 'Apple' and B contains 'had'") Note: you do not need the parentheses around E contains 'Apple'


1

Temporary Filter Views can't be renamed. To "delete" a a temporary Filter View, refresh the current web browser tab, open the spreadsheet in a new web browser tab or in another web browser


1

Go to Filter by condition\Custom formula and insert following: =MATCH(A2, {"amazon", "amz", "azamon"}, 0) where A2 - is cell where your data starts and row you are filtering (in example A1 is header and you filter by first row), {"amazon", "amz", "azamon"} - list of your conditions.


1

This is what is shown in the linked spreadsheet Please note that each column includes a dropdown button. That is the way that Filter/Filter views work on Google Sheets. If you want that the filter shows all the values in the array, you should change the shape of the array from 3 columns 1 row to 1 column 3 rows as follows ={"Picard";"Q";"Data"} If you ...


1

Edit per OP's comment (This works great if the rows have no spaces in them but my data does have extra blank rows in between the rows of data as well.) =IFNA(QUERY({A3:I11},"select Col1, Col"&MATCH(B16,A2:I2,0)&", Col"&MATCH(B16,A2:I2,0)+1&" where Col"&MATCH(B16,A2:I2,0)&" !=0 and Col1 is not null"),"missing") ...


1

Your formula would be: =QUERY({G2:I,ArrayFormula(VLOOKUP(H2:H,{C2:C,B2:B},2,0))}, "select Col4, Col1, Col2, Col3 where Col3='passed' order by Col4 , Col2 ") Functions used: + VLOOKUP + ARRAYFORMULA + QUERY


1

Unless you want to delve into the Advanced Google Services or Filter View, a "quick and dirty" workaround would be to rename your filters giving them a serial number: 01-myfilter, 02-yourfilter, 03-onemore. Rather a practical solution of re-naming than a "Google developer solution".


1

The Google Sheets UI, the Google Apps Script service and the Google Sheets API do not include a way to sort the list of filter views on the Google Sheets UI, but the filter views are editable so you could each item in the filter view to make have the settings that you want. NOTE: Google Apps Script doesn't support filter views directly but you could use the ...


1

Here's a way to achieve this =FILTER(B1:B10, iferror(ArrayFormula( VLOOKUP(B1:B10,$A$1:$A$10,1,false)) ,true)) EDIT : If you have a lot of values this is maybe a better solution : =FILTER(B1:B10,ArrayFormula(COUNTIF($A$1:$A$10,B1:B10)-1)) Breakdown of the formula VLOOKUP: Vlookup to see if there's a match between values in B and A. It returns ...


1

Well, it's clunky, but this works: INDIRECT("R" & ROW() & "C" & COLUMN(),false) e.g. = AND(INDIRECT("R" & ROW() & "C" & COLUMN(),false) <> "Financial",INDIRECT("R" & ROW() & "C" & COLUMN(),false) <> "Income") I could make it a lot neater if I could pack some of this into a custom function, but I can't seem to ...


1

Instead of using the Google Sheets UI filters, use a formula to filter the results. To do this you could use functions like FILTER and QUERY


1

At this time IMPORTRANGE can't import only visible rows. Currently there isn't any built-in function that does that and this can't be done by using a custom function as accesing an external range require authorization and custom functions can't use methods that require it. The alternative is to use another kind of script, and add-on or a third party ...


1

I ran the test (video here) which shows what happens for each of the operations. I tested: Cut & Paste, Copy & Paste & Delete, and Dragging cells. You can see from the resulting image that the only operation that gave the expected results while in filtered view was to copy the cells, paste them, and then delete the data from the original cells. ...


Only top voted, non community-wiki answers of a minimum length are eligible