Filter multiple columns with same function?

Question

=filter('Handle Database'!A:AF,'Handle Database'!Z:Z<>"Plastic",'Handle Database'!X:X<>"Plastic",'Handle Database'!Y:Y<>"Plastic")

Is there a more concise way of writing this? Instead of listing out each individual column separately? Or should I use =QUERY instead?

player0 · Accepted Answer · 2020-05-10 23:38:08Z

2

try:

=ARRAYFORMULA(QUERY({'Handle Database'!A:AF},  
 "where "&TEXTJOIN(" and ", 1, "not Col"&COLUMN(X:Z)&" = 'Plastic'")))

edited May 10, 2020 at 23:38

answered May 9, 2020 at 17:44

player0

131k14 gold badges91 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jonas Blazinskas Over a year ago

docs.google.com/spreadsheets/d/… Not working for some reason look at the page "Filtered Database" please. Additionally if I wanted to add more criteria such as Glass,Blue Steel,Wood,Oak. How would I go about that? And beyond that what if I wanted multiple other conditions that I want to filter the database by on other columns is that possible?

Collectives™ on Stack Overflow

Filter multiple columns with same function?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related