Search code examples
if-statementgoogle-sheetsfilterconditional-statementsgoogle-query-language

Retrieve only durations with negative numbers


Would like to retrieve data from range H, where any duration has negative number. Please bear in mind that I actually have over 10k rows and this is just an example.

enter image description here


Solution

  • try like this:

    =FILTER(A:B; B:B<0)