0

I tried to use this formula below on my Google Sheet for around 10,000 row data:

=ARRAYFORMULA(IF(LEN(L3:L),M3:M&" - "&MMULT((M3:M=TRANSPOSE(M3:M))*(ROW(M3:M)>=TRANSPOSE(ROW(M3:M))),SIGN(ROW(M3:M)))+0,IFERROR(1/0)))

but it came out error message.

"The resulting array was too large"

Can please advice me good solution?

Improve this question

1 Answer 1

Reset to default
0

The first thing to try, because is the simplest action, is to remove the blank rows below your data. Another simple option is to replace the open-ended references (L3:L, M3:M) by closed-end references i.e. L3:L10, M3:M10. You also might use functions like ARRAY_CONSTRAIN, FILTER, QUERY to limit the size for the values returned by the open-ended references.

Related

Improve this answer
2

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.