Home > Software engineering >  Why am I getting this ARRAY_LITERAL when combining QUERY LAMBDA in Google Sheets?
Why am I getting this ARRAY_LITERAL when combining QUERY LAMBDA in Google Sheets?

Time:12-04

Trying to apply enter image description here

I'd appreciate your help!

CodePudding user response:

It looks like the error message you are getting is due to a syntax error in your formula. In particular, the error occurs because you are using the LAMBDA function inside the byrow function, but you are not providing the correct number of arguments to the LAMBDA function.

To fix this error, you can update your formula as follows:

Use the LAMBDA function to define a named function that takes one argument (each). Inside the LAMBDA function, use the query function to retrieve the latest entries from the B:H range that match the value of each. Use the filter function to filter the unique values in the B2:B range, and use the byrow function to apply the named function (defined using LAMBDA) to each value in the B2:B range. Here is an example of how your formula could look after making these changes:

=filter({unique(B2:B);byrow(unique(B2:B),LAMBDA(each, query(B:H,"select * where B matches "&each&" order by H Desc limit 1", 0)))}, unique(B2:B)<>"")
  • Related