16

So like my title states I would like to select via a query only the rows where certain cells are not blank/empty.

I have 4 pools that I have a form for collecting their chemistry. In separate sheets I would like to display each pool's data.

I'm expecting some incomplete submissions but if I get just one value I would still like to get it, however I don't want anywhere that pool values are completely empty.

This is the query that I thought might work however I only get the headers. This is the example sheet anyone can work on.

=QUERY('Form Responses 1'!A:N,"SELECT C,E,G,H WHERE G !='' OR H !='' ORDER BY C, E ASC", 1)

ORDER BY doesn't work either. Am I missing something?

Improve this question
0

1 Answer 1

Reset to default
31

Please try: 

=QUERY('Form Responses 1'!A:N,"SELECT C,E,G,H where G is not null or H is not null order by C,E")
Improve this answer
2
  • 2
    That worked perfectly. Didn't know about is not null
    – CamSyl
    Commented Jan 12, 2015 at 22:41
  • 9
    Just be aware that not null see a cell with a string as empty because with the not NULL command only cells with number values in them are not empty. Checking for emptiness with text strings: WHERE B != '' Checking for emptiness with numerical strings: WHERE B is not NULL
    – Jacob Hamfeldt Kold
    Commented Mar 24, 2017 at 15:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.