Sunday, 14 February 2021

How to use Google query with "order by"

 =QUERY(IMPORTRANGE("1ZTtsquwfJIlTJisS7gD_13u4Evfcz4Nr-T9N9p3-SYQ/edit#gid=620793866","Call Data!$B$20000:$K$40000"),"select Col4,Col5,Col10 where Col1= '"&B40&"'and Col4 >= Date '"&TEXT(A2,"yyyy-MM-dd")&"' and Col4 <= Date '"&TEXT(B2,"yyyy-MM-dd")&"' order by Col4",0)

No comments:

Post a Comment