CODEWITHSUNDEEP
google-sheets
vico
vico

Reputation: 18175

Filter according several column data

I need to filter only rows that contains values in all A,B,C cells. I know how to filter according one column, But how to write formula that looks to 3 conditions?

enter image description here

Upvotes: 0

Views: 36

Answers (1)

Ed Nelson
Ed Nelson

Reputation: 10259

You can use filter:

=filter(A:C,NOT(ISBLANK(A:A)),NOT(ISBLANK(B:B)),NOT(ISBLANK(C:C)))

or query:

=query(A:C,"select A,B,C where A!='' and B!='' and C!=''")

Upvotes: 2

Related Questions