I'm using the ArrayFormula to calculate multiple ranges and it's slow because it's trying to calculate everything in that range, even though it has nothing in it.

Is there a way I can limit the ArrayFormula to only calculate a certain amount of rows in a range?

  • 3
    Can you show as at least the formula ? – JPV Apr 16 '15 at 15:18

If your are using as a parameter a range that is too large, i.e. whole columns references like A:A, but you don't require the whole range, change it to a smaller range like A1:10. Also you could use functions like FILTER, QUERY, OFFSET, among others, to return small enough ranges.

Your Answer

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