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


but it came out error message.

"The resulting array was too large"

Can please advice me good solution?


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.


  • @Mr.Liew You are welcome. Please read What should I do when someone answers my question?
    – Rubén
    Aug 13 '21 at 17:01
  • @Mr.Liew if want to ask for clarification instead of editing the question post a comment but if you want to ask a follow-up question please do that by posting a new question.
    – Rubén
    Aug 13 '21 at 17:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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