Dynamic array creating a range of numbers

[AndrewMD]

Hi Everyone,

I have a number in one cell in A1 = 30 and I want to return a dynamic array that starts from 1 and runs up to the number in A1.

Is this possible?

Thanks!

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

If you have 2021 or 365 how about

=sequence(a1)

 

[felixstraube]

Sure. What version of Excel do you have?

 

[AndrewMD]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

If you have 2021 or 365 how about

=sequence(a1)

Thanks folks, I'm using 365 and this works fabulously. Love that sequence formula, didn't realise it worked like that too!

 

[Fluff]

You're welcome & thanks for the feedback.
Please don't forget to update your account with your Excel version.