Retrieve only durations with negative numbers

user_8157523 0
Viewed 44

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

google-query-language google-sheets conditional-statements if-statement filter
2 Answers

You can try =QUERY(G5:H8,"SELECT A,B WHERE B < 0",1)

user_155166990

try like this:

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