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.
At this time, on Google Sheets
owner and users with permissions to edit a protected range
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.
to create temporary and to save view filters
to edit own ...
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".
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 ...
Here's a way to achieve this
EDIT : If you have a lot of values this is maybe a better solution :
Breakdown of the formula VLOOKUP:
Vlookup to see if there's a match between values in B and A. It returns ...
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 ...
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,...
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.
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.
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. ...