Retrieve only durations with negative numbers-CodePudding

Home > OS > Retrieve only durations with negative numbers

Retrieve only durations with negative numbers

Time：01-29

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.

CodePudding user response：

try like this:

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

CodePudding user response：

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

Page link：https//www.codepudding.com/os/280796.html

Prev:Accessing a public google sheet's data directly from client-side JavaScript

Next:Formula with range how to add adding another row in that range

Tags：

Links：
CodePudding