Cell A1 holds a numerical value (e.g. 10), and I'd like to output the list of numbers from 1 to that number in B1:

enter image description here

What's the formula I need for B1? It seems trivial, and I know it probably requires ARRAYFORMULA but I just don't know where to go from there.


1 Answer 1


It is as simple as using the following sequence formula


google sheets sequential/incremental numbers

Or you even could have something like this:


enter image description here

You could even use the SEQUENCE function for dates


creating an array of dates

  • I was hoping there was an easy way to do this :) Mar 7, 2020 at 12:49
  • The SEQUENCE function is relatively new but really great. Glad it helped :) Mar 8, 2020 at 6:34

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.