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