Jan 16 2022 07:42 AM
Hello. I'm trying to figure out if I can convert a query code from google sheet to excel.
When I try to open it in excel I'm having a different code
My original code on one of the sheet:
=Arrayformula(query({TO_TEXT('ILLINOIS SERVICE'!$A7:$N);TO_TEXT('ILLINOIS CLEANING'!$A7:$N)},"Select Col1,Col2,Col3,Col4,Col5,Col6 ,Col7,Col8,Col9,Col10 Where Col14 is not null"))
but when I open it in excel I get:
=IFERROR(@__xludf.DUMMYFUNCTION("Arrayformula(query({TO_TEXT('ILLINOIS SERVICE'!$A7:$N7353);TO_TEXT('ILLINOIS CLEANING'!$A7:$N7353)},""Select Col1,Col2,Col3,Col4,Col5,Col6 ,Col7,Col8,Col9,Col10 Where Col14 is not null""))"),"15")
on my second original code is:
=QUERY('UNPAID INVOICES'!$A7:$M,"select A,B,C,D,E,F,G,H,I,J where K>0 and L < date '" & text(today(), "yyyy-mm-dd") & "' ")
but in excel it shows:
=IFERROR(@__xludf.DUMMYFUNCTION("Arrayformula(query({TO_TEXT('ILLINOIS SERVICE'!$A7:$N7353);TO_TEXT('ILLINOIS CLEANING'!$A7:$N7353)},""Select Col1,Col2,Col3,Col4,Col5,Col6 ,Col7,Col8,Col9,Col10 Where Col14 is not null""))"),"15")