Listing individual numbers from a whole number

[JakeMann]

Hi All,

Not sure if this is possible (or if I'm going to explain what I want clearly!) -

In one cell I have a number, for example 300
In another cell I want to populate all the cells running down with 1, 2, 3 etc up to 300

For my example -

In E2 I have 300 - but that could be any number. In cells I2:I502 I want a formula that will look at the number in E2 and list the individual numbers 1-300.

So I would expect an individual formula in I2:502.

Any ideas?

[Ron Coderre]

With
E2: a number....300
I1: any label....Seq

This regular formula, copied down through I502, begins the list of sequential numbers

Please Login or Register  to view this content.

In the above example, the formulas list values from 1 through 300.

Is that something you can work with?

[JakeMann]

Hi Ron,

That's perfect, mate. Works exactly how I want it.

What does the N mean in the formula?

[Ron Coderre]

The N() function converts its referenced item to a number, if possible, otherwise: zero
A1: mytext
A2: =A1*10 resolves to #VALUE!
A3: =N(A1)*10 resolves to 0

So in the formula I posted, it's a shortcut for processing the referenced cell, even if it contains text.

I hope that helps.