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?

Glorfindel
  • 2,379
  • 5
  • 19
  • 28
CamSyl
  • 527
  • 3
  • 5
  • 13

1 Answers1

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")
pnuts
  • 17,883
  • 5
  • 55
  • 103