Finding missing data

ISBLANK() accepts a cell address and returns TRUE if that cell is empty. This provides a useful way of checking for missing data.

Logical conditions like ISBLANK() are useful for filtering datasets: you can keep only the rows where some condition is TRUE. Data filtering can be done using FILTER(), which takes two arguments. The first argument is the range of the data that you want to filter, and the second argument is the range containing the logical values to filter on.

For example, if the data (not including the header row) is in A2:E10, and the final column E contains the logical values to filter on, you would type =FILTER(A2:E10, E2:E10).