i have list of results include column duration time. want exclude rows duration zero. tried following without success.
not m contains '00:00:00.000'
m > 0
not m contains '12:00:00 am'
i suspect has way duration formatted in uploaddata!a:m
sheet. here's formula in question , spreadsheet in question.
=query(uploaddata!a:m,"select b, c, h, i, m not(c) contains '"&join("|",filter!a:a)&"' , b contains 'incoming' , not b null , not h null ",1)
figured out! used filter function remove 0 durations before wrapping query. you'll notice had change column references letters numbers work correctly.
=query(filter(uploaddata!a:m,uploaddata!m:m>0),"select col2, col3, col8, col9, col13 not col3 contains '"&join("' , not col3 contains '",filter(filter!a2:a,filter!a2:a<>""))&"' , col2 contains 'incoming' , not col2 null , not col9 null order col13",1)
Comments
Post a Comment