what is the zoho sheet formula equivalent to this google sheet formula?
In the google spreadsheet this is what I have
I have forumula in column K:
=unique(B2:C)
Then I have formula in Column M:
=map(
filter(K2:K, len(K2:K)), filter(L2:L, len(K2:K)),
lambda(
model, trim,
torow(filter(C2:G, B2:B = model, C2:C = trim))
)
)
When I try to move this over to zoho sheets it does not work. See google spreadsheet screenshot. I am trying to the red section to look like the green section.