I’ve downloaded an excel and it looks like
And I want to make a filter that does
if DATA1 = 7 AND DATA2 is more than 20
OR
if DATA1 = 6 AND DATA2 is more than 3000
OR
etc etc for about 10 cases
with standard filter, I can do it to one or two cases, but there is a limit. Also, as it is a filter that I will be using on updated spreadsheets every some days, is there any way to save the filter and apply it in 2 seconds to a new file?
This office suite comes with a database component where sorting and filtering just works with no limits.
You may try the so called “advanced filtering”. Advanced filtering reads filter criteria from cells.
advancedFilter.ods (24.3 KB)
I use more the advanced filter in cases like this but the main point is: Put your cursor in a source-cell of the filter-area and check the Data Menu: There is a refresh-entry.
.
So while I can not save and copy the filter, I can remove the data, save the cleaned file as template under another name and use it for new data as quick as I can paste new data there.