I want to filter a data table and want to exclude 5 sets of data found in this table I've tried this formula to start with the exclusion of the first data but I'm not getting the correct answer. But maybe I'm doing something wrong.
=FILTER('Teller Stats'!B7:L1000,ISNA(MATCH('Teller Stats'!L7:L1000=0,)))
the table is: Teller Stats'!B7:L1000
I want the data with any amount bigger or smaller than 0 to be excluded in Column L
I want all blank cells in Column E to be excluded
I want any cells that has any of the following 3 strings to be excluded from column F:
Deposita; CashNet; Cash Connect
So the final result will give me everything else found in: Teller Stats'!B7:L1000
=FILTER('Teller Stats'!B7:L1000,ISNA(MATCH('Teller Stats'!L7:L1000=0,)))
the table is: Teller Stats'!B7:L1000
I want the data with any amount bigger or smaller than 0 to be excluded in Column L
I want all blank cells in Column E to be excluded
I want any cells that has any of the following 3 strings to be excluded from column F:
Deposita; CashNet; Cash Connect
So the final result will give me everything else found in: Teller Stats'!B7:L1000