=QUERY({IMPORTRANGE("1ZTtsquwfJIlTJisS7gD_13u4Evfcz4Nr-T9N9p3-SYQ/edit#gid=847332267","Action Data!$A$23000:$H$54002");
IMPORTRANGE("1ZTtsquwfJIlTJisS7gD_13u4Evfcz4Nr-T9N9p3-SYQ/edit#gid=847332267","Action Data!$A$54003:$H$78005")},
"select Col2,Col4,Col5,Col8 where Col1='"&B32&"' and Col3= '"&B11&"' and Col2 >= Date '"&TEXT(A2,"yyyy-MM-dd")&"' and Col2 <= Date '"&TEXT(B2,"yyyy-MM-dd")&"'")
No comments:
Post a Comment