I need help converting a code from google sheet to excel

Occasional Visitor

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")

 

 

 

0 Replies