I have an issue with my query where I have numeric cells and text cells that if all are empty I do not want to retrieve them however if anyone of the cells are not empty I want to retrieve that row.
I know that
is not Null is used for numeric cells and
<>'' is used for text cells.
Let's say the table looks like this in the original table of data. Sheet is called 'Data'.
Column | A | B | C | D | Cell Type | Number | Text | Number | Text | Row1 | 7 | Stuff | 5.33 | Sweet | Row2 | 8 | World | | Hello | Row3 | 9 | | | | Row4 | | | | | Row5 | | | 9.77 | |
I want to be able to grab all the rows except Row4
If I use this query, it should work correctly with the cell types. Correct?
=Query(Data!A:D, Select D,B,A,C Where A Is Not Null OR B <>'' OR C Is Not Null OR D <>'')
I applied this to my example spreadsheet which uses the same principles as this query. Except that it only works on two of my sheets. The sheets that don't have much data to select; the query only grabs the headers. In my mindfor the second tab called DonSmithPool, it should be grabbing a few of the rows that have text comments and for the last tab called TeachPool it should grab 1 row.